Alegeri extra (view)

Data source: Expert Forum · About: Metodologie

1 row where Competitori = "4.34"

✎ View and edit SQL

This data as json, CSV (advanced)

Competitori 1 ✖

  • 4.34 · 1 ✖
Alegeri Tip Descriptiv Data desfășurării Data Candidați Competitori Independenți Venituri Cheltuieli
2008L L Alegeri locale 1 iunie 2008 01.06.2008 366814 4.34   77467422.39 91566845.52000001

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;