MySQL - Get counts of `car models` by `car make`
You have to GROUP BY both make and model, to get the count
SELECT `make`,`model`, COUNT(*) as `countmakemodel`
FROM `cars_new`
WHERE `make` IN ('Chrysler', 'Ferrari', 'Citroen', 'Dodge')
GROUP BY `make`,`model`