user: Question: Who is the captain of the team in Southampton? 
Columns: ['Team', 'Location', 'County', 'Division', 'Home ground', 'Coach', 'Captain']
Types: ['text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Derbyshire Falcons', 'Derby', 'Derbyshire', 'North', 'County Ground', 'Karl Krikken', 'Wayne Madsen']
SQL:

assistant: SELECT "Captain" FROM "Table" WHERE "Location" = 'Southampton';