What bridge is the longest bridge measured in feet? | Do you want the name of the longest bridge measured in feet? | Yes
SELECT name FROM bridge WHERE length_feet  =   ( select max ( length_feet )  from bridge ) 
longest bridge measured in feet refers to MAX(length_feet); name of the bridge refers to name;