How many rooms in each building have a capacity of over 50?
SELECT count(*) ,  building FROM classroom WHERE capacity  >  50 GROUP BY building
rooms in each building refers to GROUP BY building; capacity of over 50 refers to capacity > 50; counting rooms refers to COUNT(*);