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

how many actors have appeared in each musical?, sort bar in desc order.
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 T2.Name DESC
SELECT "T2"."Name", COUNT(*) FROM "actor" "T1" JOIN "musical" "T2" ON "T1"."Musical_ID" = "T2"."Musical_ID" GROUP BY "T1"."Musical_ID" ORDER BY "T2"."Name" DESC