Database: architecture
Question: show the name of all bridges that was designed by american archtect, and sort the result by the bridge feet length.
SQL:
SELECT t1.name FROM bridge AS t1 JOIN architect AS t2 ON t1.architect_id  =  t2.id WHERE t2.nationality  =  'American' ORDER BY t1.length_feet