Venituri cheltuieli alegeri - total (view)

Data source: Expert Forum · About: Metodologie

16 rows sorted by Venituri descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Tip competitor

Alegeri Tip competitor Venituri ▲ Cheltuieli
2020L p 177780309.53000003 167248814.60999995
2020P i 169345114.71 169407354.56399998
2019EUR p 95126378.81 90341169.60000002
2008L p 77467422.39 91566845.52000001
2019PR p 71230145.55 77996855.77000001
2008P p 70366161.64000002 84920728.19
2016L p 58741439.92000001 53660759.57000001
2012P p 52814942.879999995 61631501.31000001
2016P p 51756805.21 50905225.730000004
2012L p 51612145 61677485
2009PR p 28599008.22 44518061.28
2014PR p 15222566 32230686
2007EUR p 14168911.080000002 22909000.219999995
2009EUR p 13184406.93 21121893.179999996
2014EUR p 12222397 21159896
  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;