sql 统计

结果纵向（适用于没有固定值的统计）

SELECT `type`,operator,COUNT(`operator`) AS ol FROM review_tb 
-- where state = 4001
GROUP BY operator,`type`

结果横向(适应于有固定值的统计)

SELECT 
SUM(CASE `type` WHEN '券生产' THEN 1 ELSE 0 END) '券生产',
SUM(CASE `type` WHEN '商品发布' THEN 1 ELSE 0 END) '商品发布',
SUM(CASE `type` WHEN '实名认证' THEN 1 ELSE 0 END) '实名认证'
FROM review_tb
WHERE create_time BETWEEN '2022-6-8' AND '2023-8-9' 
AND state=4001