SELECT max(capacity) ,  avg(capacity) ,  building FROM classroom GROUP BY building
What are the greatest and average capacity for 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
What are the greatest and average capacity for rooms in each building ?