Table schema:
CREATE TABLE publication (Publisher VARCHAR)

Question: Show different publishers together with the number of publications they have.
SQL: SELECT Publisher, COUNT(*) FROM publication GROUP BY Publisher