Return a histogram on how many actors have appeared in each musical?, could you display in asc by the total number?
CREATE TABLE actor (
    Actor_ID int,
    Name text,
    Musical_ID int,
    Character text,
    Duration text,
    age int
)

CREATE TABLE musical (
    Musical_ID int,
    Name text,
    Year int,
    Award text,
    Category text,
    Nominee text,
    Result text
)
SELECT T2.Name, COUNT(*) FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID = T2.Musical_ID GROUP BY T1.Musical_ID 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: Return a histogram on how many actors have appeared in each musical?, could you display in asc by the total number? ### Input: CREATE TABLE actor (
    Actor_ID int,
    Name text,
    Musical_ID int,
    Character text,
    Duration text,
    age int
)

CREATE TABLE musical (
    Musical_ID int,
    Name text,
    Year int,
    Award text,
    Category text,
    Nominee text,
    Result text
) ### Response: SELECT T2.Name, COUNT(*) FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID = T2.Musical_ID GROUP BY T1.Musical_ID ORDER BY COUNT(*)