human
Schema:
architect (id, name, nationality, gender)
bridge (architect_id, id, name, location, length_meters, length_feet)
mill (architect_id, id, location, name, type, built_year, notes)
Please answer with SQL.
assistant
Sure, I understand.
human
What is the length in meters of each bridge?
assistant
SELECT length_meters FROM bridge;
human
Find the maximum length.
assistant
SELECT MAX( length_meters ) FROM bridge;
human
Show the maximum length in meters of the bridges and the name of the architect that made it.
assistant
SELECT MAX( T1.length_meters ) , T2.name FROM bridge AS T1 JOIN architect AS T2 ON T1.architect_id = T2.id ;