Show different publishers together with the number of publications they have.
create table publication (publisher varchar, PRIMARY KEY (publisher))
select publisher, count(*) from publication group by publisher