Compute the total the total number across publisher as a pie chart.
CREATE TABLE publication (
    Publication_ID int,
    Book_ID int,
    Publisher text,
    Publication_Date text,
    Price real
)

CREATE TABLE book (
    Book_ID int,
    Title text,
    Issues real,
    Writer text
)
SELECT Publisher, COUNT(*) FROM publication GROUP BY Publisher
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: Compute the total the total number across publisher as a pie chart. ### Input: CREATE TABLE publication (
    Publication_ID int,
    Book_ID int,
    Publisher text,
    Publication_Date text,
    Price real
)

CREATE TABLE book (
    Book_ID int,
    Title text,
    Issues real,
    Writer text
) ### Response: SELECT Publisher, COUNT(*) FROM publication GROUP BY Publisher