Relation Election 5
Show the biggest party in each cantonread "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 |