Draw a bar chart of publisher versus the total number, and list in descending by the the total number .
CREATE TABLE book (
    Book_ID int,
    Title text,
    Issues real,
    Writer text
)

CREATE TABLE publication (
    Publication_ID int,
    Book_ID int,
    Publisher text,
    Publication_Date text,
    Price real
)
SELECT Publisher, COUNT(*) FROM publication GROUP BY Publisher ORDER BY COUNT(*) DESC
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: Draw a bar chart of publisher versus the total number, and list in descending by the the total number . ### Input: CREATE TABLE book (
    Book_ID int,
    Title text,
    Issues real,
    Writer text
)

CREATE TABLE publication (
    Publication_ID int,
    Book_ID int,
    Publisher text,
    Publication_Date text,
    Price real
) ### Response: SELECT Publisher, COUNT(*) FROM publication GROUP BY Publisher ORDER BY COUNT(*) DESC