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)
CREATE TABLE architect (id CLOB, name CLOB, nationality CLOB, gender CLOB)

What is the maximum length in meters for the bridges and what are the architects' names?
SELECT MAX(T1.length_meters), T2.name FROM bridge AS T1 JOIN architect AS T2 ON T1.architect_id = T2.id
SELECT MAX("T1"."length_meters"), "T2"."name" FROM "bridge" "T1" JOIN "architect" "T2" ON "T1"."architect_id" = "T2"."id"