What is the range of capacity among rooms in each building?
SELECT max ( capacity )  ,  min ( capacity )  ,  building FROM classroom GROUP BY building
range of capacity among rooms in each building = MAX(capacity) - MIN(capacity); for each building refers to GROUP BY building;