Show publishers that have less than one publication?
select publisher from publication group by publisher having count ( * ) > 1
Show all the publishers?
select publisher from publication
What is the highest price that a publisher earns?
select price from publication order by price desc limit 1
What is the lowest price that a publisher earns?
select price from publication order by price limit 1