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)

Bar chart x axis nominee y axis the total number, and rank in descending by the total number.
SELECT Nominee, COUNT(*) FROM musical GROUP BY Nominee ORDER BY COUNT(*) DESC
SELECT "Nominee", COUNT(*) FROM "musical" GROUP BY "Nominee" ORDER BY COUNT(*) DESC