Can you show all rooms with a capacity larger than 50?
select * from classroom where capacity > 50
Can you display only the number of rooms currently in the table?
select room_number from classroom where capacity > 50
How many unique room numbers are currently in the table?
select count ( distinct room_number ) from classroom where capacity > 50