SELECT "Bezirk",
SUM("SQ_WuD") as "GesamtSQ_WuD", SUM("SQ_Mob") as "GesamtSQ_Mob", SUM("SQ_IuG") as "GesamtSQ_IuG", SUM("SQ_LuF") as "GesamtSQ_LuF",
SUM("SQ_EE_WAKA") as "GesamtSQ_WAKA", SUM("SQ_EE_WIKA") as "GesamtSQ_WIKA", SUM("SQ_EE_PV") as "GesamtSQ_PV", SUM("SQ_EE_Solartherm") as "GesamtSQ_Solartherm", SUM("SQ_EE_Biomasse") as "GesamtSQ_BM", SUM("SQ_EE_Biogas") as "GesamtSQ_Biogas", SUM("SQ_EE_Umweltw") as "GesamtSQ_Umweltw", SUM("PeG_WuD") as "GesamtPeG_WuD", SUM("PeG_Mob") as "GesamtPeG_Mob", SUM("PeG_IuG") as "GesamtPeG_IuG", SUM("PeG_LuF") as "GesamtPeG_LuF",
SUM("PeG_WAKA") as "GesamtPeG_WAKA", SUM("PeG_WIKA") as "GesamtPeG_WIKA", SUM("PeG_PV") as "GesamtPeG_PV", SUM("PeG_Solartherm") as "GesamtPeG_Solartherm", SUM("PeG_Biomasse") as "GesamtPeG_BM", SUM("PeG_Biogas") as "GesamtPeG_Biogas", SUM("PeG_Umweltw") as "GesamtPeG_Umweltw",
FROM "Zielwertberechnung"
WHERE "Bezirk" = (SELECT "Bezirk" FROM "Zielwertberechnung" WHERE "Gemeinde" = ${document.getElementById("mySearch").value})
GROUP BY "Bezirk"