SELECT
单位,
SUM(CASE Quarter WHEN 1 THEN score ELSE 0 END) AS 一季度,
SUM(CASE Quarter WHEN 1 THEN score ELSE 0 END) AS 二季度,
SUM(CASE Quarter WHEN 1 THEN score ELSE 0 END) AS 三季度,
SUM(CASE Quarter WHEN 1 THEN score ELSE 0 END) AS 四季度,
SUM(score) AS 年度,
year
FROM tb
GROUP BY
单位,year
单位,
SUM(CASE Quarter WHEN 1 THEN score ELSE 0 END) AS 一季度,
SUM(CASE Quarter WHEN 1 THEN score ELSE 0 END) AS 二季度,
SUM(CASE Quarter WHEN 1 THEN score ELSE 0 END) AS 三季度,
SUM(CASE Quarter WHEN 1 THEN score ELSE 0 END) AS 四季度,
SUM(score) AS 年度,
year
FROM tb
GROUP BY
单位,year
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货