CREATE TABLE editor (Editor_ID NUMBER, Name CLOB, Age FLOAT)
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)

Show the names of editors that are on the committee of journals with sales bigger than 3000, and count them by a bar chart, order Name from low to high order.
SELECT Name, COUNT(Name) FROM journal_committee AS T1 JOIN editor AS T2 ON T1.Editor_ID = T2.Editor_ID JOIN journal AS T3 ON T1.Journal_ID = T3.Journal_ID WHERE T3.Sales > 3000 GROUP BY Name ORDER BY Name
SELECT "Name", COUNT("Name") FROM "journal_committee" "T1" JOIN "editor" "T2" ON "T1"."Editor_ID" = "T2"."Editor_ID" JOIN "journal" "T3" ON "T1"."Journal_ID" = "T3"."Journal_ID" AND "T3"."Sales" > 3000 GROUP BY "Name" ORDER BY "Name"