Who is the advisor of student with ID 1004?
CREATE TABLE Student (Advisor VARCHAR, StuID VARCHAR)
SELECT Advisor FROM Student WHERE StuID = 1004
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Student (Advisor VARCHAR, StuID VARCHAR) Question: Who is the advisor of student with ID 1004? [/INST] SELECT Advisor FROM Student WHERE StuID = 1004 </s>