CREATE TABLE mill (TYPE VARCHAR2)

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 FETCH FIRST 1 ROWS ONLY