Translate the following question to SQL: show the name of all bridges that was designed by american archtect, and sort the result by the bridge feet length.

Schema: CREATE TABLE architect (
    id TEXT   PRIMARY KEY,
    name TEXT,
    nationality TEXT,
    gender TEXT,
    UNIQUE (id)
);

CREATE TABLE bridge (
    architect_id INT,
    id INT   PRIMARY KEY,
    name TEXT,
    location TEXT,
    length_meters REAL,
    length_feet REAL,
    UNIQUE (id),
    FOREIGN KEY (architect_id) REFERENCES architect(id)
);

CREATE TABLE mill (
    architect_id INT,
    id INT   PRIMARY KEY,
    location TEXT,
    name TEXT,
    type TEXT,
    built_year INT,
    notes TEXT,
    UNIQUE (id),
    FOREIGN KEY (architect_id) REFERENCES architect(id)
);
user
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
assistant