Table: arch_bridge_spans
Columns: rank
name
span_metres
span_feet
material
year_opened
country

Question: What is the lowest amount of Span metres when the year opened is 2007, the country is China, rank is less than 13, and the span feet is less than 1378?
SQL: SELECT MIN("span_metres") FROM arch_bridge_spans WHERE "year_opened" = '2007' AND "country" = 'china' AND "rank" < 13 AND "span_feet" < 1378

Question: Which country's material was concrete when the span metres were less than 270, span feet is more than 837, and the year opened was 1943?
SQL: SELECT "country" FROM arch_bridge_spans WHERE "material" = 'concrete' AND "span_metres" < 270 AND "span_feet" > 837 AND "year_opened" = '1943'