What is the gender of the teacher with last name "Medhurst"?
CREATE TABLE TEACHERS (gender VARCHAR, last_name VARCHAR)
SELECT gender FROM TEACHERS WHERE last_name = "Medhurst"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE TEACHERS (gender VARCHAR, last_name VARCHAR) Question: What is the gender of the teacher with last name "Medhurst"? [/INST] SELECT gender FROM TEACHERS WHERE last_name = "Medhurst" </s>