CREATE TABLE classroom (building VARCHAR(255), room_number VARCHAR(255), capacity INTEGER)
Find the room number of the rooms which can sit 50 to 100 students and their buildings.
    
SQL: SELECT building, room_number FROM classroom WHERE capacity BETWEEN 50 AND 100