CREATE TABLE publication (publication_id DECIMAL, book_id DECIMAL, publisher TEXT, publication_date TEXT, price DECIMAL)
CREATE TABLE book (book_id DECIMAL, title TEXT, issues DECIMAL, writer TEXT)

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"