CREATE TABLE musical (Musical_ID INT, Name TEXT, Year INT, Award TEXT, Category TEXT, Nominee TEXT, Result TEXT)
CREATE TABLE actor (Actor_ID INT, Name TEXT, Musical_ID INT, Character TEXT, Duration TEXT, age INT)

How many musicals has each nominee been nominated for Plot them as bar chart, show in asc by the total number.
SELECT Nominee, COUNT(*) FROM musical GROUP BY Nominee ORDER BY COUNT(*)
SELECT "Nominee", COUNT(*) FROM "musical" GROUP BY "Nominee" ORDER BY COUNT(*) NULLS FIRST