What is the occupation of the person with a hometown of Hampshire?
CREATE TABLE table_name_17 (occupation VARCHAR, hometown VARCHAR)
SELECT occupation FROM table_name_17 WHERE hometown = "hampshire"
### Context: CREATE TABLE table_name_17 (occupation VARCHAR, hometown VARCHAR) ### Question: What is the occupation of the person with a hometown of Hampshire? ### Answer: SELECT occupation FROM table_name_17 WHERE hometown = "hampshire"