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

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 NULLS LAST LIMIT 1