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

How many actors have appeared in each musical. Plot them as bar chart.
SELECT T2.Name, COUNT(*) FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID = T2.Musical_ID GROUP BY T1.Musical_ID
SELECT "T2"."Name", COUNT(*) FROM "actor" "T1" JOIN "musical" "T2" ON "T1"."Musical_ID" = "T2"."Musical_ID" GROUP BY "T1"."Musical_ID"