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)

Who are the nominees who were nominated for either of the Bob Fosse or Cleavant Derricks awards, and count them by a bar chart
SELECT Nominee, COUNT(Nominee) FROM musical WHERE Award = "Tony Award" OR Award = "Cleavant Derricks" GROUP BY Nominee
SELECT "Nominee", COUNT("Nominee") FROM "musical" WHERE "Award" = "Cleavant Derricks" OR "Award" = "Tony Award" GROUP BY "Nominee"