CREATE TABLE table_14760 ("Series" TEXT, "Name" TEXT, "Hometown" TEXT, "Occupation" TEXT, "Status" TEXT)

What is the occupation of the person with a hometown of Hampshire?
SELECT "Occupation" FROM table_14760 WHERE "Hometown" = 'hampshire'
SELECT "Occupation" FROM "table_14760" WHERE "Hometown" = 'hampshire'