SELECT COUNT(*), building FROM classroom WHERE capacity > 50 GROUP BY building
Find the number of rooms with more than 50 capacity for each building.
CREATE TABLE classroom (
    building VARCHAR,
    capacity INTEGER
)