Venituri cheltuieli alegeri - total (view)

Data source: Expert Forum · About: Metodologie

16 rows sorted by Venituri

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Tip competitor

Alegeri Tip competitor Venituri ▼ Cheltuieli
  i 21700 21620.78
2014EUR p 12222397 21159896
2009EUR p 13184406.93 21121893.179999996
2007EUR p 14168911.080000002 22909000.219999995
2014PR p 15222566 32230686
2009PR p 28599008.22 44518061.28
2012L p 51612145 61677485
2016P p 51756805.21 50905225.730000004
2012P p 52814942.879999995 61631501.31000001
2016L p 58741439.92000001 53660759.57000001
2008P p 70366161.64000002 84920728.19
2019PR p 71230145.55 77996855.77000001
2008L p 77467422.39 91566845.52000001
2019EUR p 95126378.81 90341169.60000002
2020P i 169345114.71 169407354.56399998
2020L p 177780309.53000003 167248814.60999995

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW "Venituri cheltuieli alegeri - total" AS SELECT Alegeri, "Tip competitor", SUM(Venituri) AS Venituri, SUM(Cheltuieli) AS Cheltuieli FROM "Cheltuieli campanie" GROUP BY Alegeri UNION SELECT Alegeri, "Tip competitor", SUM(Venituri) AS Venituri, SUM(Cheltuieli) AS Cheltuieli FROM "Venituri și cheltuieli campanie" GROUP BY Alegeri;