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
Please show the most common publication date.
assistant
SELECT Publication_Date FROM publication GROUP BY Publication_Date ORDER BY COUNT(*) DESC LIMIT 1
human
What are the distinct publishers of publications with price higher than 5000000?
assistant
SELECT DISTINCT Publisher FROM publication WHERE Price > 5000000
human
List the publisher of the publication with the highest price.
assistant
SELECT Publisher FROM publication ORDER BY Price DESC LIMIT 1
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
human
List the publication dates of publications with 3 lowest prices.
assistant
SELECT Publication_Date FROM publication ORDER BY Price ASC LIMIT 3
human
What are the dates of publications in descending order of price?
assistant
SELECT Publication_Date FROM publication ORDER BY Price DESC ;