SELECT MAX(capacity), AVG(capacity), building FROM classroom GROUP BY building
Temukan kapasitas maksimum dan rata -rata di antara kamar -kamar di setiap gedung.
CREATE TABLE classroom (building VARCHAR, capacity INTEGER)