GROUP BY 如果为空值显示为0

原代码

SELECT PROVINCE, count(id) 
FROM GUTAN_POLICY 
Where 
(GAS_SOURCE = '稻田甲烷' or GAS_SOURCE LIKE '%,稻田甲烷' or GAS_SOURCE LIKE '%稻田甲烷,%' or GAS_SOURCE LIKE '%稻田甲烷,%') 
GROUP BY PROVINCE

修改后

select A.PROVINCE,nvl(num,0)
from (
SELECT DISTINCT PROVINCE  FROM GUTAN_POLICY
)A
LEFT JOIN 
(
select PROVINCE ,count(ID) as num from GUTAN_POLICY
	where  (GAS_SOURCE = '稻田甲烷' or GAS_SOURCE LIKE '%,稻田甲烷' or GAS_SOURCE LIKE '%稻田甲烷,%' or GAS_SOURCE LIKE '%稻田甲烷,%')
	group by PROVINCE
) B
on A.PROVINCE=B.PROVINCE