您可以使用 MySQL 的 SUM()
函数来统计每个月的订单量。具体来说,您可以使用以下 SQL 语句:
SELECT city, SUM(CASE WHEN month = 1 THEN 1 ELSE 0 END) as 'Jan',
SUM(CASE WHEN month = 2 THEN 1 ELSE 0 END) as 'Feb',
SUM(CASE WHEN month = 3 THEN 1 ELSE 0 END) as 'Mar',
SUM(CASE WHEN month = 4 THEN 1 ELSE 0 END) as 'Apr',
SUM(CASE WHEN