Find the room number of the rooms which can sit 50 to 100 students and their buildings.
CREATE TABLE classroom (building VARCHAR, room_number VARCHAR, capacity INTEGER)
SELECT building, room_number FROM classroom WHERE capacity BETWEEN 50 AND 100
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE classroom (building VARCHAR, room_number VARCHAR, capacity INTEGER) Question: Find the room number of the rooms which can sit 50 to 100 students and their buildings. [/INST] SELECT building, room_number FROM classroom WHERE capacity BETWEEN 50 AND 100 </s>