Skip to content
Snippets Groups Projects

Mise à jour de la parité des élus suite aux élections législatives

1 file
+ 1
1
Compare changes
  • Side-by-side
  • Inline
+ 1
1
@@ -30,7 +30,7 @@ run("DROP VIEW IF EXISTS rne;")
@@ -30,7 +30,7 @@ run("DROP VIEW IF EXISTS rne;")
run(
run(
"""
"""
CREATE OR REPLACE VIEW rne AS (
CREATE OR REPLACE VIEW rne AS (
SELECT 'Conseil département' as elu, 4 as ordre, code_du_departement, code_sexe, date_de_naissance FROM elus_conseiller_departemental
SELECT 'Conseil départemental' as elu, 4 as ordre, code_du_departement, code_sexe, date_de_naissance FROM elus_conseiller_departemental
UNION
UNION
SELECT 'Conseil régional' as elu, 6 as ordre, insee_dep as code_du_departement, code_sexe, date_de_naissance
SELECT 'Conseil régional' as elu, 6 as ordre, insee_dep as code_du_departement, code_sexe, date_de_naissance
FROM elus_regional inner join ign_departement ign on elus_regional.code_de_la_region = ign.insee_reg
FROM elus_regional inner join ign_departement ign on elus_regional.code_de_la_region = ign.insee_reg
Loading