【mysql】分组分类统计数量

需求

代码实现

SELECT a.name,SUM(CASE WHEN a.TYPE_ = '在校' THEN 1 ELSE 0 END) AS '在校次数',SUM(CASE WHEN a.TYPE_ = '在家' THEN 1 ELSE 0 END) AS ‘在家次数’FROM table a GROUP BY a.name;