Table schema:
CREATE TABLE classroom (building VARCHAR, capacity INTEGER)

Question: Find the number of rooms with more than 50 capacity for each building.
SQL: SELECT COUNT(*), building FROM classroom WHERE capacity > 50 GROUP BY building