CASE WHEN Land IN ("USA","Kanada","Mexiko") THEN "Nordamerika" WHEN Land IN ("England","Frankreich")THEN "Europa" ELSE "Sonstige" END