你的SQL语句这么写: SELECT department, SUM(CASE monthly WHEN 1 THEN fact ELSE 0 END) AS Q1, SUM(CASE monthly WHEN 2 THEN fact ELSE 0 END) AS Q2, SUM(CASE monthly WHEN 3 THEN fact ELSE 0 END) AS Q3, SUM(CASE monthly WHEN 4 THEN fact ELSE 0 END) AS Q4, SUM(CASE monthly WHEN 5 THEN fact ELSE 0 END) AS Q5, SUM(CASE monthly WHEN 6 THEN fact ELSE 0 END) AS Q6, SUM(CASE monthly WHEN 7 THEN fact ELSE 0 END) AS Q7, SUM(CASE monthly WHEN 8 THEN fact ELSE 0 END) AS Q8, SUM(CASE monthly WHEN 9 THEN fact ELSE 0 END) AS Q9, SUM(CASE monthly WHEN 10 THEN fact ELSE 0 END) AS Q10, SUM(CASE monthly WHEN 11 THEN fact ELSE 0 END) AS Q11, SUM(CASE monthly WHEN 12 THEN fact ELSE 0 END) AS Q12 FROM expenditure GROUP BY department
SELECT department,
SUM(CASE monthly WHEN 1 THEN fact ELSE 0 END) AS Q1,
SUM(CASE monthly WHEN 2 THEN fact ELSE 0 END) AS Q2,
SUM(CASE monthly WHEN 3 THEN fact ELSE 0 END) AS Q3,
SUM(CASE monthly WHEN 4 THEN fact ELSE 0 END) AS Q4,
SUM(CASE monthly WHEN 5 THEN fact ELSE 0 END) AS Q5,
SUM(CASE monthly WHEN 6 THEN fact ELSE 0 END) AS Q6,
SUM(CASE monthly WHEN 7 THEN fact ELSE 0 END) AS Q7,
SUM(CASE monthly WHEN 8 THEN fact ELSE 0 END) AS Q8,
SUM(CASE monthly WHEN 9 THEN fact ELSE 0 END) AS Q9,
SUM(CASE monthly WHEN 10 THEN fact ELSE 0 END) AS Q10,
SUM(CASE monthly WHEN 11 THEN fact ELSE 0 END) AS Q11,
SUM(CASE monthly WHEN 12 THEN fact ELSE 0 END) AS Q12
FROM expenditure
GROUP BY department