user: ### NOW ANSWER:
Question: How long is the bridge in Villeneuve-sur-Lot?
Columns: ['Name', 'Location', 'Land', 'Longest span in s metre ( feet )', 'Arch type', 'Completed']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Pont de la Libération', 'Villeneuve-sur-Lot', 'France', '96 (315)', 'uc', '1919']
SQL:

assistant: SELECT "Longest span in s metre ( feet )" FROM "Table" WHERE "Location" = 'Villeneuve-sur-Lot';