Venituri cheltuieli alegeri (view)

Data source: Expert Forum · About: Metodologie

3 rows where Alegeri = "2019EUR" and Cheltuieli = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Alegeri Tip alegeri Partid Venituri Cheltuieli
2019EUR Tip alegeri P.PRO 0 0
2019EUR Tip alegeri PRU 0 0
2019EUR Tip alegeri PSR 0 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW "Venituri cheltuieli alegeri" AS SELECT Alegeri, "Tip alegeri", Partid, Venituri, Cheltuieli FROM 'Cheltuieli campanie' WHERE "Tip competitor" = 'p' UNION SELECT Alegeri, 'Tip alegeri', Partid, Venituri, Cheltuieli FROM 'Venituri și cheltuieli campanie' WHERE "Tip competitor" = 'p';