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)

Show different nominees and the number of musicals they have been nominated Plot them as bar chart, and display from low to high by the x axis.
SELECT Nominee, COUNT(*) FROM musical GROUP BY Nominee ORDER BY Nominee
SELECT "Nominee", COUNT(*) FROM "musical" GROUP BY "Nominee" ORDER BY "Nominee"