CREATE TABLE bridge (name VARCHAR2, architect_id VARCHAR2, length_feet VARCHAR2)
CREATE TABLE architect (id VARCHAR2, nationality VARCHAR2)

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" "t1" JOIN "architect" "t2" ON "t1"."architect_id" = "t2"."id" AND "t2"."nationality" = 'American' ORDER BY "t1"."length_feet"