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)

Return a bar chart on how many musicals has each nominee been nominated for?, and could you order the total number in desc order?
SELECT Nominee, COUNT(*) FROM musical GROUP BY Nominee ORDER BY COUNT(*) DESC
SELECT "Nominee", COUNT(*) FROM "musical" GROUP BY "Nominee" ORDER BY COUNT(*) DESC