Database: college_2
Question: What are the greatest and average capacity for rooms in each building?
SQL:
SELECT max(capacity) ,  avg(capacity) ,  building FROM classroom GROUP BY building