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)
CREATE TABLE bridge (architect_id NUMBER, id NUMBER, name CLOB, location CLOB, length_meters NUMBER, length_feet NUMBER)

What is the id, name and nationality of the architect who built most mills?
SELECT T1.id, T1.name, T1.nationality FROM architect AS T1 JOIN mill AS T2 ON T1.id = T2.architect_id GROUP BY T1.id ORDER BY COUNT(*) DESC LIMIT 1
SELECT "T1"."id", "T1"."name", "T1"."nationality" FROM "architect" "T1" JOIN "mill" "T2" ON "T1"."id" = "T2"."architect_id" GROUP BY "T1"."id" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY