What are the room numbers and corresponding buildings for classrooms which can seat between 50 to 100 students?
SELECT building ,  room_number FROM classroom WHERE capacity BETWEEN 50 AND 100
classrooms which can seat between 50 to 100 students refers to capacity BETWEEN 50 AND 100; room numbers refers to room_number; corresponding buildings refers to building;