show the name of all bridges that was designed by american archtect, and sort the result by the bridge feet length.
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
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
[{'name': 'Hazarchishma Natural Bridge'}, {'name': 'Jiangzhou Arch'}, {'name': "Shipton's Arch"}, {'name': 'Xian Ren Qiao (Fairy Bridge)'}]