Find the maximum and average capacity among rooms in each building.
SELECT max(capacity) ,  avg(capacity) ,  building FROM classroom GROUP BY building
maximum capacity among rooms in each building refers to MAX(capacity); average capacity among rooms in each building refers to AVG(capacity);