select MONTH(submit_time),sum(CASE WHEN grade=1 THEN 1 ELSE 0 END) as grade1,
sum(CASE WHEN grade=2 THEN 1 ELSE 0 END) as grade2 from hidden_danger_record where YEAR(submit_time)=2021 group by MONTH(submit_time)
业务说明
21年根据月份分组,并统计grade字段为1的个数及为2的个数
结果