human
Schema:
publication (Publication_ID, Book_ID, Publisher, Publication_Date, Price)
book (Book_ID, Title, Issues, Writer)
Please answer with SQL.
assistant
Sure, I understand.
human
Show publishers that have less than one publication?
assistant
SELECT Publisher FROM publication GROUP BY Publisher HAVING COUNT( * ) > 1 ;