Skip to content
Snippets Groups Projects

add idade to homicidios

Merged Rafael S Castilho requested to merge add_age_to_homicidios into master
1 file
+ 2
2
Compare changes
  • Side-by-side
  • Inline
+ 2
2
@@ -7,7 +7,7 @@ SELECT
@@ -7,7 +7,7 @@ SELECT
cast(obito as float)*100000/((cast(pop_ibge as float)/cast(pop_pnad as float))*cast(pop_filtrada as float)) as taxa_homicidio,
cast(obito as float)*100000/((cast(pop_ibge as float)/cast(pop_pnad as float))*cast(pop_filtrada as float)) as taxa_homicidio,
sim.ano_obito as ano,
sim.ano_obito as ano,
sim."ocor_SIGLA_UF" as uf,
sim."ocor_SIGLA_UF" as uf,
sim.idade_obito_anos as idade,
sim.idade_obito_anos,
sim.def_raca_cor as raca_cor
sim.def_raca_cor as raca_cor
FROM
FROM
(select count(*) as obito, * from sim
(select count(*) as obito, * from sim
@@ -67,7 +67,7 @@ group by
@@ -67,7 +67,7 @@ group by
sim.obito, pnad.pop_filtrada,
sim.obito, pnad.pop_filtrada,
sim."ocor_SIGLA_UF",
sim."ocor_SIGLA_UF",
sim.def_raca_cor,
sim.def_raca_cor,
sim.idade,
sim.idade_obito_anos,
pnad.pop_ibge,
pnad.pop_ibge,
pnad.pop_pnad
pnad.pop_pnad
order by
order by
Loading