What is the maximum length in meters for the bridges and what are the architects' names?
create table architect (name varchar, id varchar, PRIMARY KEY (name)); create table bridge (length_meters integer, architect_id varchar, PRIMARY KEY (length_meters))
select max(t1.length_meters), t2.name from bridge as t1 join architect as t2 on t1.architect_id = t2.id