English Français Deutsch

Relation Election 5

Show the biggest party in each canton
read "ef2019.csv"
dup
project kanton, fiktive_waehlende max
join natural
select round(fiktive_waehlende) = round(fiktive_waehlende_max)
project kanton, partei
print

kanton partei
Zürich SVP
Bern / Berne SVP
Luzern CVP
Uri CVP
Schwyz SVP
Obwalden SVP
Nidwalden SVP
Glarus BDP
Zug SVP
Fribourg / Freiburg SP
Solothurn SVP
Basel-Stadt SP
Basel-Landschaft SVP
Schaffhausen SVP
Appenzell Ausserrhoden SVP
Appenzell Innerrhoden CVP
St. Gallen SVP
Graubünden / Grigioni / Grischun SVP
Aargau SVP
Thurgau SVP
Ticino FDP
Vaud FDP
Valais / Wallis CVP
Neuchâtel FDP
Genève GPS
Jura SP