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)

Show different nominees and the number of musicals they have been nominated in a bar chart, sort in desc by the Y-axis.
SELECT Nominee, COUNT(*) FROM musical GROUP BY Nominee ORDER BY COUNT(*) DESC
SELECT "Nominee", COUNT(*) FROM "musical" GROUP BY "Nominee" ORDER BY COUNT(*) DESC