SELECT max(capacity) ,  avg(capacity) ,  building FROM classroom GROUP BY building
Find the maximum and average capacity among rooms in each building.
SELECT max ( capacity ) , avg ( capacity ) , building FROM classroom GROUP BY building
select max ( capacity ) , avg ( capacity ) , building from classroom group by building
Find the maximum and average capacity among rooms in each building .