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
[{'max(capacity)': 47, 'avg(capacity)': 36.5, 'building': 'Alumni'}, {'max(capacity)': 12, 'avg(capacity)': 12.0, 'building': 'Bronfman'}, {'max(capacity)': 11, 'avg(capacity)': 10.5, 'building': 'Chandler'}, {'max(capacity)': 18, 'avg(capacity)': 18.0, 'building': 'Drown'}, {'max(capacity)': 27, 'avg(capacity)': 27.0, 'building': 'Fairchild'}, {'max(capacity)': 59, 'avg(capacity)': 59.0, 'building': 'Garfield'}, {'max(capacity)': 65, 'avg(capacity)': 37.5, 'building': 'Gates'}, {'max(capacity)': 34, 'avg(capacity)': 34.0, 'building': 'Grace'}, {'max(capacity)': 51, 'avg(capacity)': 51.0, 'building': 'Lambeau'}, {'max(capacity)': 10, 'avg(capacity)': 10.0, 'building': 'Lamberton'}, {'max(capacity)': 30, 'avg(capacity)': 26.0, 'building': 'Main'}, {'max(capacity)': 92, 'avg(capacity)': 92.0, 'building': 'Nassau'}, {'max(capacity)': 97, 'avg(capacity)': 97.0, 'building': 'Painter'}, {'max(capacity)': 28, 'avg(capacity)': 28.0, 'building': 'Polya'}, {'max(capacity)': 12, 'avg(capacity)': 11.0, 'building': 'Power'}, {'max(capacity)': 60, 'avg(capacity)': 60.0, 'building': 'Rathbone'}, {'max(capacity)': 109, 'avg(capacity)': 49.333333333333336, 'building': 'Saucon'}, {'max(capacity)': 113, 'avg(capacity)': 113.0, 'building': 'Stabler'}, {'max(capacity)': 115, 'avg(capacity)': 93.0, 'building': 'Taylor'}, {'max(capacity)': 120, 'avg(capacity)': 76.0, 'building': 'Whitman'}]