Database: architecture
Question: What is the most common mill type, and how many are there?
SQL:
SELECT TYPE ,  count(*) FROM mill GROUP BY TYPE ORDER BY count(*) DESC LIMIT 1