Can you tell me which room number has a capacity higher than the average capacity?
select room_number from classroom where capacity > ( select avg ( capacity ) from classroom )
What is the range of capacity among rooms in each building?
select max ( capacity ), min ( capacity ), building from classroom group by building
Which building houses the room that has the maximum capacity?
select building from classroom order by capacity desc limit 1
Which building houses the room that has the minimum capacity?
select building from classroom order by capacity limit 1