Using Count to find the number of occurrences

select car_made, count(*) as occurrences
from cars
group by car_made
order by occurrences desc, car_made

Do you mean this?

select car_make, count(*) from cars
group by car_makes

SELECT ... GROUP BY

http://dev.mysql.com/doc/refman/5.0/en/select.html

For example:
SELECT CarName, COUNT(CarName) AS CarCount FROM tbl GROUP BY CarName

Related