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

Calculate the number of actors in each duration of actors using a bar chart, and I want to list by the total number in ascending.
SELECT Duration, COUNT(Duration) FROM actor GROUP BY Duration ORDER BY COUNT(Duration)
SELECT "Duration", COUNT("Duration") FROM "actor" GROUP BY "Duration" ORDER BY COUNT("Duration")