CREATE TABLE bridge (architect_id NUMBER, id NUMBER, name CLOB, location CLOB, length_meters NUMBER, length_feet NUMBER)
CREATE TABLE architect (id CLOB, name CLOB, nationality CLOB, gender CLOB)
CREATE TABLE mill (architect_id NUMBER, id NUMBER, location CLOB, name CLOB, type CLOB, built_year NUMBER, notes CLOB)

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