Group and count the name attribute for visualizing a bar chart, display in ascending by the Name.
CREATE TABLE journal (
    Journal_ID int,
    Date text,
    Theme text,
    Sales int
)

CREATE TABLE journal_committee (
    Editor_ID int,
    Journal_ID int,
    Work_Type text
)

CREATE TABLE editor (
    Editor_ID int,
    Name text,
    Age real
)
SELECT Name, COUNT(Name) FROM editor GROUP BY Name 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: Group and count the name attribute for visualizing a bar chart, display in ascending by the Name. ### Input: CREATE TABLE journal (
    Journal_ID int,
    Date text,
    Theme text,
    Sales int
)

CREATE TABLE journal_committee (
    Editor_ID int,
    Journal_ID int,
    Work_Type text
)

CREATE TABLE editor (
    Editor_ID int,
    Name text,
    Age real
) ### Response: SELECT Name, COUNT(Name) FROM editor GROUP BY Name ORDER BY Name