SELECT year(payment_date), sum(CASE month(payment_date) WHEN 01 THEN amount END) '一月份销售额', sum(CASE month(payment_date) WHEN 02 THEN amount END) '二月份销售额', sum(CASE month(payment_date) WHEN 03 THEN amount END) '三月份销售额', sum(CASE month(payment_date) WHEN 04 THEN amount END) '四月份销售额', sum(CASE month(payment_date) WHEN 05 THEN amount END) '五月份销售额', sum(CASE month(payment_date) WHEN 06 THEN amount END) '六月份销售额', sum(CASE month(payment_date) WHEN 07 THEN amount END) '七月份销售额', sum(CASE month(payment_date) WHEN 08 THEN amount END) '八月份销售额', sum(CASE month(payment_date) WHEN 09 THEN amount END) '九月份销售额', sum(CASE month(payment_date) WHEN 10 THEN amount END) '十月份销售额', sum(CASE month(payment_date) WHEN 11 THEN amount END) '十一月份销售额', sum(CASE month(payment_date) WHEN 12 THEN amount END) '十二月份销售额' from payment group by year(payment_date);
sum(CASE month(payment_date) WHEN 01 THEN amount END) '一月份销售额',
sum(CASE month(payment_date) WHEN 02 THEN amount END) '二月份销售额',
sum(CASE month(payment_date) WHEN 03 THEN amount END) '三月份销售额',
sum(CASE month(payment_date) WHEN 04 THEN amount END) '四月份销售额',
sum(CASE month(payment_date) WHEN 05 THEN amount END) '五月份销售额',
sum(CASE month(payment_date) WHEN 06 THEN amount END) '六月份销售额',
sum(CASE month(payment_date) WHEN 07 THEN amount END) '七月份销售额',
sum(CASE month(payment_date) WHEN 08 THEN amount END) '八月份销售额',
sum(CASE month(payment_date) WHEN 09 THEN amount END) '九月份销售额',
sum(CASE month(payment_date) WHEN 10 THEN amount END) '十月份销售额',
sum(CASE month(payment_date) WHEN 11 THEN amount END) '十一月份销售额',
sum(CASE month(payment_date) WHEN 12 THEN amount END) '十二月份销售额'
from payment
group by year(payment_date);