Show ids for all students who have advisor 1121.
CREATE TABLE Student (StuID VARCHAR, Advisor VARCHAR)
SELECT StuID FROM Student WHERE Advisor = 1121
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Student (StuID VARCHAR, Advisor VARCHAR) Question: Show ids for all students who have advisor 1121. [/INST] SELECT StuID FROM Student WHERE Advisor = 1121 </s>