Task: Text to Code
Input (English): SQL: SELECT name FROM bridge ORDER BY length_meters Desc
Feedback: Change length meters with length feet and Add nationality of architect table equals American .
Output (English): 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