A bar chart showing the number of publication dates of books, sort Y from high to low order.
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 Publication_Date, COUNT(Publication_Date) FROM publication GROUP BY Publication_Date ORDER BY COUNT(Publication_Date) 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: A bar chart showing the number of publication dates of books, sort Y from high to low order. ### 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 Publication_Date, COUNT(Publication_Date) FROM publication GROUP BY Publication_Date ORDER BY COUNT(Publication_Date) DESC