What office did Henry Hagner run for on the prohibition ticket?
CREATE TABLE table_name_31 (office VARCHAR, prohibition_ticket VARCHAR)
SELECT office FROM table_name_31 WHERE prohibition_ticket = "henry hagner"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_31 (office VARCHAR, prohibition_ticket VARCHAR) Question: What office did Henry Hagner run for on the prohibition ticket? [/INST] SELECT office FROM table_name_31 WHERE prohibition_ticket = "henry hagner" </s>