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)

Give me a histogram for how many musicals has each nominee been nominated for?
SELECT Nominee, COUNT(*) FROM musical GROUP BY Nominee
SELECT "Nominee", COUNT(*) FROM "musical" GROUP BY "Nominee"