How do I write this GROUP BY query in MYSQL?

Question

Suppose I have a column called "fruits" I want to select all of the top fruits, ranked by fruits (and group by + count).

Fruits:
orange
orange
apple
banana
apple
apple

In this case, the select statement would return:

apple, 3
orange, 2
banana, 1

Answer 1

Untested:

SELECT 
   fruit_name, 
   COUNT(fruit_id)
FROM
   fruit
GROUP BY
   fruit_name
ORDER BY
   COUNT(fruit_id) DESC

Answer 2

select fruits, count(fruits)
from table
group by fruits
order by count(fruits) desc

Answer 3

SELECT fruitname, COUNT(*) AS ttl
FROM fruits 
GROUP BY fruitname 
ORDER BY ttl DESC

Answer 4

Tested:

select fruits, count(fruits)
from fruit
group by fruits
order by 2 desc