What are the greatest and average capacity for rooms in each building?
select max(capacity), avg(capacity), building from classroom group by building