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