CREATE TABLE book (book_id NUMBER, title CLOB, issues NUMBER, writer CLOB)
CREATE TABLE publication (publication_id NUMBER, book_id NUMBER, publisher CLOB, publication_date CLOB, price NUMBER)

How many distinct publication dates are there in our record?
SELECT COUNT(DISTINCT publication_date) FROM publication
SELECT COUNT(DISTINCT "publication_date") FROM "publication"