SELECT marke, COUNT(marke) FROM saga2012 WHERE ((internenummer !='') AND( (firma='17') || ((firma='70') && (filiale='36')) ) AND (preis > 0))AND(((neuwagen='1') AND (energieeffizienzklasse!=''))|| ((neuwagen='1') AND (pkwnfz!='PKW')) ) GROUP BY marke