instruction: How many rooms in each building have a capacity of over 50 Visualize by bar chart, and sort by the total number in asc.
response: SELECT building, COUNT(*) FROM classroom WHERE capacity > 50 GROUP BY building ORDER BY COUNT(*)