select T1."EBENE21" as "Ebene21",
	   T1."EBENE22" as "Absatzkanal_mit_Bez",
	   T1."EBENE23" as "Ebene23",
	   T1."EBENE24" as "Ebene24",
	   T1."EBENE25" as "Ebene25",
	   T1."EBENE26" as "Ebene26",
	   T1."EBENE27" as "Ebene27",
	   T1."EBENE28" as "Ebene28",
	   T1."EBENE29" as "Ebene29",
	   T1."EBENE30" as "Ebene30",
	   CASE WHEN (T1."EBENE22" IN ('100 - Bilanz')) THEN ('100') ELSE ((left(T1."EBENE22",2))) END as "Absatzkanal"
from "Absatzkanal.csv" T1
where ((CASE WHEN (T1."EBENE22" IN ('100 - Bilanz')) THEN ('100') ELSE ((left(T1."EBENE22",2))) END) BETWEEN '00' AND '99')