SELECT Nominee, COUNT(*) FROM musical GROUP BY Nominee ORDER BY COUNT(*) DESC
Show different nominees and the number of musicals they have been nominated in a bar chart, sort in desc by the Y-axis.
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
)