instruction: What are the names of the different categories, and how many films are in each? Show me the bar graph, could you rank X-axis in asc order please?
response: SELECT name, COUNT(*) FROM film_category AS T1 JOIN category AS T2 ON T1.category_id = T2.category_id GROUP BY T1.category_id ORDER BY name