What are the majors of male (sex is M) students?
CREATE TABLE STUDENT (Major VARCHAR, Sex VARCHAR)
SELECT Major FROM STUDENT WHERE Sex = "M"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE STUDENT (Major VARCHAR, Sex VARCHAR) Question: What are the majors of male (sex is M) students? [/INST] SELECT Major FROM STUDENT WHERE Sex = "M" </s>