CREATE TABLE table_name_17 (occupation VARCHAR, hometown VARCHAR)

What is the occupation of the person with a hometown of Hampshire?
SELECT occupation FROM table_name_17 WHERE hometown = "hampshire"
SELECT "occupation" FROM "table_name_17" WHERE "hampshire" = "hometown"