有sales数据表如下:
期望输出如下:
SQL语句如下:
SELECT
year,
SUM( IF(quarter='1', quantity, 0) ) AS quarter1,
SUM( IF(quarter='2', quantity, 0) ) AS quarter2,
SUM( IF(quarter='3', quantity, 0) ) AS quarter3,
SUM( IF(quarter='4', quantity, 0) ) AS quarter4
FROM
sales
GROUP BY
year