CREATE TABLE bridge (name VARCHAR(255), architect_id VARCHAR(255), length_feet VARCHAR(255)); CREATE TABLE architect (id VARCHAR(255), nationality VARCHAR(255))
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