CREATE TABLE table_1870 ("Team" CLOB, "Location" CLOB, "County" CLOB, "Division" CLOB, "Home ground" CLOB, "Coach" CLOB, "Captain" CLOB)

Who is the captain of the team in Southampton?
SELECT "Captain" FROM table_1870 WHERE "Location" = 'Southampton'
SELECT "Captain" FROM "table_1870" WHERE "Location" = 'Southampton'