CREATE TABLE journal_committee (Editor_ID NUMBER, Journal_ID NUMBER, Work_Type CLOB)
CREATE TABLE journal (Journal_ID NUMBER, Date CLOB, Theme CLOB, Sales NUMBER)
CREATE TABLE editor (Editor_ID NUMBER, Name CLOB, Age FLOAT)

Group and count the name attribute for visualizing a bar chart, and display total number in asc order.
SELECT Name, COUNT(Name) FROM editor GROUP BY Name ORDER BY COUNT(Name)
SELECT "Name", COUNT("Name") FROM "editor" GROUP BY "Name" ORDER BY COUNT("Name")