Alegeri extra (view)

Data source: Expert Forum · About: Metodologie

1 row where Competitori = 17

✎ View and edit SQL

This data as json, CSV (advanced)

Alegeri Tip Descriptiv Data desfășurării Data Candidați Competitori Independenți Venituri Cheltuieli
2019EUR EUR Parlamentul European 26 mai 2019 26.05.2019 695 17   95126378.81 90341169.60000002

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW "Alegeri extra" AS SELECT a.*, b.Venituri, b.Cheltuieli FROM (SELECT Cod AS Alegeri, Tip, Descriptiv, "Data desfășurării", Data, Candidați, Competitori, Independenți FROM 'Legenda alegeri') a JOIN (SELECT alegeri, Venituri, Cheltuieli FROM "Venituri cheltuieli alegeri - total" ) b on a.Alegeri = b.Alegeri;