CREATE TABLE event (Event_ID NUMBER, Date CLOB, Venue CLOB, Name CLOB, Event_Attendance NUMBER)
CREATE TABLE news_report (journalist_ID NUMBER, Event_ID NUMBER, Work_Type CLOB)
CREATE TABLE journalist (journalist_ID NUMBER, Name CLOB, Nationality CLOB, Age CLOB, Years_working NUMBER)

Find the average age of journalists working on different role type, show the result with a bar chart, sort y axis in ascending order.
SELECT Work_Type, AVG(t1.Age) FROM journalist AS t1 JOIN news_report AS t2 ON t1.journalist_ID = t2.journalist_ID GROUP BY t2.Work_Type ORDER BY AVG(t1.Age)
SELECT "Work_Type", AVG("t1"."Age") FROM "journalist" "t1" JOIN "news_report" "t2" ON "t1"."journalist_ID" = "t2"."journalist_ID" GROUP BY "t2"."Work_Type" ORDER BY AVG("t1"."Age")