SELECT building ,  room_number FROM classroom WHERE capacity BETWEEN 50 AND 100
Find the room number of the rooms which can sit 50 to 100 students and their buildings.
SELECT building , room_number FROM classroom WHERE capacity BETWEEN 50 AND 100
select building , room_number from classroom where capacity between value and value
Find the room number of the rooms which can sit 50 to 100 students and their buildings .