Table schema:
CREATE TABLE table_name_17 (occupation VARCHAR, hometown VARCHAR)

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