Find the rooms of faculties with rank professor who live in building NEB.
CREATE TABLE FACULTY (Room VARCHAR, Rank VARCHAR, Building VARCHAR)
SELECT Room FROM FACULTY WHERE Rank = "Professor" AND Building = "NEB"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE FACULTY (Room VARCHAR, Rank VARCHAR, Building VARCHAR) Question: Find the rooms of faculties with rank professor who live in building NEB. [/INST] SELECT Room FROM FACULTY WHERE Rank = "Professor" AND Building = "NEB" </s>