Table: longest_arches
Columns: name
location
land
longest_span_in_s_metre_feet
arch_type
completed

Question: How long is the bridge in Villeneuve-sur-Lot?
SQL: SELECT "longest_span_in_s_metre_feet" FROM longest_arches WHERE "location" = 'villeneuve-sur-lot'

Question: Which bridge was completed in 1928?
SQL: SELECT "name" FROM longest_arches WHERE "completed" = '1928'

Question: How long is the UK's Ballochmyle Viaduct?
SQL: SELECT "longest_span_in_s_metre_feet" FROM longest_arches WHERE "land" = 'uk' AND "name" = 'ballochmyle viaduct'

Question: What kind of arch is the pont de montanges (pont-des-pierres)?
SQL: SELECT "arch_type" FROM longest_arches WHERE "name" = 'pont de montanges (pont-des-pierres)'