CREATE TABLE actor (Actor_ID INT, Name TEXT, Musical_ID INT, Character TEXT, Duration TEXT, age INT)
CREATE TABLE musical (Musical_ID INT, Name TEXT, Year INT, Award TEXT, Category TEXT, Nominee TEXT, Result TEXT)

How many actors have appeared in each musical Plot them as bar chart, list in ascending by the Y-axis.
SELECT T2.Name, COUNT(*) FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID = T2.Musical_ID GROUP BY T1.Musical_ID ORDER BY COUNT(*)
SELECT "T2"."Name", COUNT(*) FROM "actor" AS "T1" JOIN "musical" AS "T2" ON "T1"."Musical_ID" = "T2"."Musical_ID" GROUP BY "T1"."Musical_ID" ORDER BY COUNT(*) NULLS FIRST