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
show the name of all bridges that was designed by american archtect, and sort the result by the bridge feet length.
CREATE TABLE bridge (
    architect_id number,
    id number,
    name text,
    location text,
    length_meters number,
    length_feet number
)

CREATE TABLE architect (
    id text,
    name text,
    nationality text,
    gender text
)

CREATE TABLE mill (
    architect_id number,
    id number,
    location text,
    name text,
    type text,
    built_year number,
    notes text
)