mysql count the number of occurrences code example

Example: mysql count number of occurrences in a column

SELECT name,COUNT(*) 
FROM tablename 
GROUP BY name 
ORDER BY COUNT(*) DESC;