What are the maximum and average capacities across all classrooms?
select max(capacity), avg(capacity) from classroom
Find these for each building.
select max(capacity), avg(capacity), building from classroom group by building