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)

Bar chart x axis publication date y axis how many publication date
SELECT Publication_Date, COUNT(Publication_Date) FROM publication GROUP BY Publication_Date
SELECT "Publication_Date", COUNT("Publication_Date") FROM "publication" GROUP BY "Publication_Date"