What are the greatest and average capacity for rooms in each building?
SELECT max(capacity) ,  avg(capacity) ,  building FROM classroom GROUP BY building
greatest capacity for rooms refers to MAX(capacity); average capacity for rooms refers to AVG(capacity); in each building refers to GROUP BY building;