CREATE TABLE bridge (architect_id DECIMAL, id DECIMAL, name TEXT, location TEXT, length_meters DECIMAL, length_feet DECIMAL)
CREATE TABLE architect (id TEXT, name TEXT, nationality TEXT, gender TEXT)
CREATE TABLE mill (architect_id DECIMAL, id DECIMAL, location TEXT, name TEXT, type TEXT, built_year DECIMAL, notes TEXT)

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" AND "t2"."nationality" = 'American' ORDER BY "t1"."length_feet" NULLS FIRST