Just compare the number of journal committees of each editor using a histogram, show bar in ascending order.
CREATE TABLE journal_committee (
    Editor_ID int,
    Journal_ID int,
    Work_Type text
)

CREATE TABLE editor (
    Editor_ID int,
    Name text,
    Age real
)

CREATE TABLE journal (
    Journal_ID int,
    Date text,
    Theme text,
    Sales int
)
SELECT Name, COUNT(*) FROM editor AS T1 JOIN journal_committee AS T2 ON T1.Editor_ID = T2.Editor_ID GROUP BY T1.Editor_ID ORDER BY Name
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: Just compare the number of journal committees of each editor using a histogram, show bar in ascending order. ### Input: CREATE TABLE journal_committee (
    Editor_ID int,
    Journal_ID int,
    Work_Type text
)

CREATE TABLE editor (
    Editor_ID int,
    Name text,
    Age real
)

CREATE TABLE journal (
    Journal_ID int,
    Date text,
    Theme text,
    Sales int
) ### Response: SELECT Name, COUNT(*) FROM editor AS T1 JOIN journal_committee AS T2 ON T1.Editor_ID = T2.Editor_ID GROUP BY T1.Editor_ID ORDER BY Name