sum(case 属性名 when 属性值1 then 1 else 0 end),意思就是某个属性下为属性值1就加1个数量,否则就作0统计。
select a_type,
SUM(CASE a_type WHEN 0 THEN 1 else 0 END) as '类型一',
SUM(CASE a_type WHEN 1 THEN 1 else 0 END) as '类型二'
from a_plan
where start_time >='2020-06-1' and end_time<='2020-06-30' #选择开始时间,结束时间
#and s='测试0604'#供应商
GROUP BY a_type