Venituri cheltuieli alegeri - total (view)

Data source: Expert Forum · About: Metodologie

16 rows sorted by Alegeri descending

✎ View and edit SQL

This data as json, CSV (advanced)

Tip competitor 2 ✖

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

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;