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

Bar chart x axis publication date y axis how many publication date, rank in desc by the X-axis.
SELECT Publication_Date, COUNT(Publication_Date) FROM publication GROUP BY Publication_Date ORDER BY Publication_Date DESC
SELECT "Publication_Date", COUNT("Publication_Date") FROM "publication" GROUP BY "Publication_Date" ORDER BY "Publication_Date" DESC NULLS LAST