Count the number of mill types.
select count(*) from mill group by type
What is the most common mill type?
select type from mill group by type order by count(*) desc limit 1
Also provide the number of mills of this type.
select type, count(*) from mill group by type order by count(*) desc limit 1