instruction: What is the greatest capacity for rooms in each building? Draw a bar chart, rank by the maximal capacity in descending please.
response: SELECT building, MAX(capacity) FROM classroom GROUP BY building ORDER BY MAX(capacity) DESC