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 ) 
room number with capacity higher than the average capacity involves comparing individual room capacity to the overall average capacity of all rooms.