SQLITE数据透视表

Question

你能帮我吗?我想要一个结果像下面的表与Sqlite

<表类> <>。task_namestatus_code部门tbody><<tr>1开始PUR2B开始ENG3C完成ENG4D不活跃的DES5E开始DES6道明>不活跃的ENG

您可以使用条件聚合，例如

SELECT department,
SUM(CASE WHEN status_code = 'START' THEN 1 END) AS "START",
SUM(CASE WHEN status_code = 'FINISH' THEN 1 END) AS "FINISH",
SUM(CASE WHEN status_code = 'NOT ACTIVE' THEN 1 END) AS "NOT ACTIVE",
COUNT(*) AS total
FROM t
GROUP BY department