Which classrooms have capacity between 50 and 100?
select * from classroom where capacity between 50 and 100
What are their buildings and room numbers?
select building, room_number from classroom where capacity between 50 and 100