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"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_17 (occupation VARCHAR, hometown VARCHAR) Question: What is the occupation of the person with a hometown of Hampshire? [/INST] SELECT occupation FROM table_name_17 WHERE hometown = "hampshire" </s>