SELECT Publisher FROM publication GROUP BY Publisher HAVING COUNT(*)  >  1
Show publishers that have more than one publication.
SELECT Publisher FROM publication GROUP BY Publisher HAVING COUNT ( * ) > 1
select publisher from publication group by publisher having count ( * ) > value
Show publishers that have more than one publication .