SELECT TYPE ,  count(*) FROM mill GROUP BY TYPE ORDER BY count(*) DESC LIMIT 1
What is the most common mill type, and how many are there?
SELECT TYPE , count ( * ) FROM mill GROUP BY TYPE ORDER BY count ( * ) DESC LIMIT 1
select type , count ( * ) from mill group by type order by count ( * ) desc limit value
What is the most common mill type , and how many are there ?