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