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

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'