A pie chart for showing the number of the names of editors that are on the committee of journals with sales bigger than 3000.
CREATE TABLE editor (
    Editor_ID int,
    Name text,
    Age real
)

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

CREATE TABLE journal (
    Journal_ID int,
    Date text,
    Theme text,
    Sales int
)
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
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: A pie chart for showing the number of the names of editors that are on the committee of journals with sales bigger than 3000. ### Input: CREATE TABLE editor (
    Editor_ID int,
    Name text,
    Age real
)

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

CREATE TABLE journal (
    Journal_ID int,
    Date text,
    Theme text,
    Sales int
) ### Response: 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