SQL小bug

SELECT SUM(DECODE(QUALITY,'严重污染',1,'重度污染',1,0)) ZWR_TS_QN,CITYCODE,AREA 
FROM TENV.AIR_CITYDAYAQI_PUBLISH A 
WHERE  TO_CHAR(TIMEPOINT,'YYYY-MM') >= '2017-10'
AND TO_CHAR(TIMEPOINT,'YYYY-MM-DD') <= '2017-12-05' 
GROUP BY CITYCODE,AREA




SELECT COUNT(*) ZWR_TS_QN,CITYCODE,AREA 
FROM TENV.AIR_CITYDAYAQI_PUBLISH A 
WHERE  TO_CHAR(TIMEPOINT,'YYYY-MM') >= '2017-10'
AND TO_CHAR(TIMEPOINT,'YYYY-MM-DD') <= '2017-12-05' 
AND A.QUALITY IN ('严重污染','重度污染')

GROUP BY CITYCODE,AREA

注意上面两个sql文件,显示的时候,上面的sql文件能显示严重污染和重度污染的值,包含没有重度污染和严重污染的城市,下面的sql则是把没有重度污染和严重污染的城市

给过滤掉了,只显示有重度污染和严重污染的城市数据!!!