Table: longest_bridges
Columns: rank
main_span_metres
main_span_feet
year_opened
country

Question: What is the main span in feet from a year of 2009 or more recent with a rank less than 94 and 1,310 main span metres?
SQL: SELECT "main_span_feet" FROM longest_bridges WHERE "year_opened" > 2009 AND "rank" < 94 AND "main_span_metres" = '1,310'

Question: What is the main span feet from opening year of 1936 in the United States with a rank greater than 47 and 421 main span metres?
SQL: SELECT "main_span_feet" FROM longest_bridges WHERE "year_opened" = 1936 AND "country" = 'united states' AND "rank" > 47 AND "main_span_metres" = '421'

Question: What is the highest rank from the year greater than 2010 with 430 main span metres?
SQL: SELECT MAX("rank") FROM longest_bridges WHERE "year_opened" > 2010 AND "main_span_metres" = '430'

Question: What is the oldest year with a main span feet of 1,640 in South Korea?
SQL: SELECT MIN("year_opened") FROM longest_bridges WHERE "main_span_feet" = '1,640' AND "country" = 'south korea'