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

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