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