SELECT  'Urbana' as col1
	,pCategoria.ds_val_opcao as categoria
	,count(ac.id_acidente) as qtd_acidente
FROM	acidente ac
	right join parametros pCategoria
	on (pCategoria.cd_tabela like 'categoria_acidente'and cast(pCategoria.cd_opcao as varchar(255)) like cast(ac.categoria as varchar(255)))
	and extract(month from ac.dt_acidente) = 09
	and extract(year from ac.dt_acidente) = 2009
	and ac.area = 2
WHERE 	pCategoria.cd_tabela = 'categoria_acidente' and pCategoria.cd_opcao not like '6'
GROUP BY pCategoria.ds_val_opcao
UNION

SELECT  'Rural' as col2
	,pCategoria.ds_val_opcao as categoria
	,count(ac.id_acidente) as qtd_acidente
FROM	acidente ac
	right join parametros pCategoria
	on (pCategoria.cd_tabela like 'categoria_acidente'and cast(pCategoria.cd_opcao as varchar(255)) like cast(ac.categoria as varchar(255)))
	and extract(month from ac.dt_acidente) = 09
	and extract(year from ac.dt_acidente) = 2009
	and ac.area = 1

WHERE 	pCategoria.cd_tabela = 'categoria_acidente' and pCategoria.cd_opcao not like '6'
GROUP BY pCategoria.ds_val_opcao