Show different nominees and the number of musicals they have been nominated in a bar chart, and order by the the total number in asc.
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
)
SELECT Nominee, COUNT(*) FROM musical GROUP BY Nominee ORDER BY COUNT(*)
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Show different nominees and the number of musicals they have been nominated in a bar chart, and order by the the total number in asc. ### Input: 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
) ### Response: SELECT Nominee, COUNT(*) FROM musical GROUP BY Nominee ORDER BY COUNT(*)