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

A bar chart showing the number of publication dates of books, and sort by the Y-axis in asc please.
SELECT Publication_Date, COUNT(Publication_Date) FROM publication GROUP BY Publication_Date ORDER BY COUNT(Publication_Date)
SELECT "Publication_Date", COUNT("Publication_Date") FROM "publication" GROUP BY "Publication_Date" ORDER BY COUNT("Publication_Date")