您可以使用这样的交叉表来做到这一点-
SELECt `year`, `month`, SUM(IF(`transporttype` = 'inbound', 1, 0)) AS `inbound`, SUM(IF(`transporttype` = 'LocalPMB', 1, 0)) AS `LocalPMB`, SUM(IF(`transporttype` = 'Long Distance',1, 0)) AS `Long Distance`, SUM(IF(`transporttype` = 'shuttle', 1, 0)) AS `shuttle`, SUM(IF(`transporttype` = 'export', 1, 0)) AS `export`, SUM(IF(`transporttype` = 'Extrusions-LongDistance', 1, 0)) AS `Extrusions-LongDistance`, SUM(IF(`transporttype` = 'Extrusions-Shuttle', 1, 0)) AS `Extrusions-Shuttle`FROM `deliveries`GROUP BY `year`, `month`
另外，您应该将transporttype值移动到查找表中，并在该表中包含transporttype_id。
