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;
human
Show all the publishers?
assistant
SELECT Publisher FROM publication;
human
What is the highest price that a publisher earns?
assistant
SELECT Price FROM publication ORDER by Price DESC LIMIT 1;
human
What is the lowest price that a publisher earns?
assistant
SELECT Price FROM publication ORDER by Price LIMIT 1 ;