SELECT count(*) ,  building FROM classroom WHERE capacity  >  50 GROUP BY building
Find the number of rooms with more than 50 capacity for each building.
SELECT count ( * ) , building FROM classroom WHERE capacity > 50 GROUP BY building
select count ( * ) , building from classroom where capacity > value group by building
Find the number of rooms with more than 50 capacity for each building .