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"