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