select distinct "Optiontype",
	   "Vehiclequotenumber",
	   "Vehicletypenu",
	   "Client Db",
	   SUM(c23) OVER (partition by "FZG_Nr") as "Gesch_Kosten_Stuetzung",
	   SUM(c22) OVER (partition by "FZG_Nr") as "Gesch_Kosten_Gesamt",
	   SUM(c21) OVER (partition by "FZG_Nr") as "Tatsaechl_Kosten_Stuetzung",
	   SUM(c20) OVER (partition by "FZG_Nr") as "Tatsaechl_Kosten_Gesamt",
	   "FZG_Nr"
from 
(select (T1."VehicleTypeNU" + (((T1."VehicleQuoteNumber")))) as "FZG_Nr",
	   T1."Client_DB" as "Client Db",
	   T1."VehicleTypeNU" as "Vehicletypenu",
	   T1."VehicleQuoteNumber" as "Vehiclequotenumber",
	   T1."OptionType" as "Optiontype",
	   CASE WHEN (T1."AnalysisCode" <> 'V') THEN (T1."ActualCost") ELSE (0) END as c20,
	   (CASE WHEN (T1."AnalysisCode" = 'V') THEN (T1."ActualCost") ELSE (0) END) as c21,
	   (CASE WHEN (T1."AnalysisCode" <> 'V') THEN (T1."EstimatedCost") ELSE (0) END) as c22,
	   (CASE WHEN (T1."AnalysisCode" = 'V') THEN (T1."EstimatedCost") ELSE (0) END) as c23
from "AUTOLINE"."import"."VS_VehicleSpecification" T1
where (T1."OptionType" = 'N')
) D1
-- order by "FZG_Nr" asc,"Vehiclequotenumber" asc