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 the musical nominee with award 'Bob Fosse' or 'Cleavant Derricks', and count them by a bar chart, and could you list from high to low by the total number?
SELECT Nominee, COUNT(Nominee) FROM musical WHERE Award = "Tony Award" OR Award = "Cleavant Derricks" GROUP BY Nominee ORDER BY COUNT(Nominee) DESC
SELECT "Nominee", COUNT("Nominee") FROM "musical" WHERE "Award" = "Cleavant Derricks" OR "Award" = "Tony Award" GROUP BY "Nominee" ORDER BY COUNT("Nominee") DESC