mysql-COALESCE-函数-汇总统计

来自兽军的研究
关键字 COALESCE + GROUP BY + WITH ROLLUP

实例 ：
SELECT
COALESCE(t.`风险等级标签`,'合计') as 风险等级标签,
SUM(case when t.`人员标签`<>'' then 1 else 0 end) as 总数,
SUM(case when t.`人员标签`='华人华侨' then 1 else 0 end) as 华人华侨,
SUM(case when t.`人员标签`='近14日境外旅居史的其他回国人员（中国籍）' then 1 else 0 end) as 境外旅居回国的中国籍人员,
SUM(case when t.`人员标签`='短期来浙商务旅行外籍人员' then 1 else 0 end) as 短期来浙商务旅行的外籍人员,
SUM(case when t.`人员标签`='境外来浙留学工作等其他外籍人员' then 1 else 0 end) as 境外来浙留学工作的外籍人员
FROM new_fkxt_hz_yq_lrt_snapshot_chuli_new t
WHERE left(t.gmt_create+0,8) between CURRENT_DATE+0-13 and CURRENT_DATE+0
GROUP BY t.`风险等级标签` WITH ROLLUP;