What is the length in meters of each bridge?
select length_meters from bridge
Find the maximum length.
select max(length_meters) from bridge
Show the maximum length in meters of the bridges and the name of the architect that made it.
select max(t1.length_meters), t2.name from bridge as t1 join architect as t2 on t1.architect_id = t2.id