Find the maximum and average capacity among rooms in each building.
CREATE TABLE classroom (building VARCHAR, capacity INTEGER)
[SQL] SELECT MAX(capacity), AVG(capacity), building FROM classroom GROUP BY building [/SQL]