CREATE TABLE publication (Publication_ID INT, Book_ID INT, Publisher TEXT, Publication_Date TEXT, Price FLOAT)
CREATE TABLE book (Book_ID INT, Title TEXT, Issues FLOAT, Writer TEXT)

A bar chart showing the number of publication dates of books, sort Y from high to low order.
SELECT Publication_Date, COUNT(Publication_Date) FROM publication GROUP BY Publication_Date ORDER BY COUNT(Publication_Date) DESC
SELECT "Publication_Date", COUNT("Publication_Date") FROM "publication" GROUP BY "Publication_Date" ORDER BY COUNT("Publication_Date") DESC NULLS LAST