(1)每年 -每月
SELECT YEAR(temp.time) '年份', MONTH(temp.time) '月份',SUM(temp.num) '月销量'
FROM temp GROUP BY YEAR(temp.time),MONTH(temp.time);
(2)按年 总量
SELECT YEAR(temp.time) '年份', SUM(temp.num) '总量'
FROM temp GROUP BY YEAR(temp.time);
(3)当前日期
SELECT t.id '年份', SUM(t.moon1) '年销量'
FROM(
SELECT YEAR(temp.time) id,
CASE WHEN YEAR(temp.time)=YEAR(NOW())-1
THEN SUM(temp.num)
END as MOON1
FROM temp WHERE 1=1 GROUP BY temp.id,temp.time
) t GROUP BY id;