Task: Text to Code
Input (English): Step 1: For each row in architect table, find the corresponding rows in bridge table.
Step 2: find the maximum length_feet in the results of step 1 whose architect's name equals Frank Lloyd Wright
Output (English): SELECT Max ( T2.length_feet ) FROM architect AS T1 JOIN bridge AS T2 ON T1.id = T2.architect_id WHERE T1.name = "Frank Lloyd Wright"