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 the publishers that have publications with price higher than 10000000 and publications with price lower than 5000000.
assistant
SELECT Publisher FROM publication WHERE Price > 10000000 INTERSECT SELECT Publisher FROM publication WHERE Price < 5000000
human
List the titles of the books in ascending order of issues.
assistant
SELECT Title FROM book ORDER BY Issues ASC
human
List the publisher of the publication with the highest price.
assistant
SELECT Publisher FROM publication ORDER BY Price DESC LIMIT 1
human
What are the dates of publications in descending order of price?
assistant
SELECT Publication_Date FROM publication ORDER BY Price DESC
human
Show the title and publication dates of books.
assistant
SELECT T1.Title , T2.Publication_Date FROM book AS T1 JOIN publication AS T2 ON T1.Book_ID = T2.Book_ID
human
Show the titles of books in descending order of publication price.
assistant
SELECT T1.Title FROM book AS T1 JOIN publication AS T2 ON T1.Book_ID = T2.Book_ID ORDER BY T2.Price DESC ;