1.case when进行统计
SQL
SELECT
COUNT(*) AS totalNumber,
COUNT(CASE WHEN a.conversation_count=0 THEN '' END ) AS valid,
COUNT(CASE WHEN a.conversation_count>0 THEN '' END ) AS pointless
FROM t_busi_conversation a
结果
其它case when用法
https://www.cnblogs.com/chenduzizhong/p/9590741.html
https://www.cnblogs.com/ichenhao/p/8383866.html
https://www.cnblogs.com/aipan/p/7770611.html
MySQL CASE WHEN 及 SELECT CASE WHEN的用法 https://www.cnblogs.com/aipan/p/7770611.html
2.行转列
MySQL多种行转列方法 https://blog.csdn.net/qq_16946803/article/details/89293210