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