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

Show different publishers together with the number of publications they have.
SELECT publisher, COUNT(*) FROM publication GROUP BY publisher
SELECT "publisher", COUNT(*) FROM "publication" GROUP BY "publisher"