Find the number of rooms with more than 50 capacity for each building.
SELECT count(*) ,  building FROM classroom WHERE capacity  >  50 GROUP BY building
number of rooms with more than 50 capacity refers to COUNT(*) WHERE capacity > 50; for each building refers to GROUP BY building;