Who are the advisors for students that live in a city with city code "BAL"?
CREATE TABLE STUDENT (Advisor VARCHAR, city_code VARCHAR)
SELECT Advisor FROM STUDENT WHERE city_code = "BAL"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE STUDENT (Advisor VARCHAR, city_code VARCHAR) Question: Who are the advisors for students that live in a city with city code "BAL"? [/INST] SELECT Advisor FROM STUDENT WHERE city_code = "BAL" </s>