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
Tell me the publishers that have publications with price higher than 10000000.
assistant
SELECT Publisher FROM publication WHERE Price > 10000000;
human
Tell me the publishers that have publications with price lower than 5000000.
assistant
SELECT Publisher FROM publication WHERE Price < 5000000 ;