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
List the titles of books that are not published.
assistant
SELECT Title FROM book WHERE Book_ID NOT IN (SELECT Book_ID FROM publication)
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
human
List the writers of the books in ascending alphabetical order.
assistant
SELECT Writer FROM book ORDER BY Writer ASC
human
What are the title and issues of the books?
assistant
SELECT Title , Issues FROM book
human
List the titles of the books in ascending order of issues.
assistant
SELECT Title FROM book ORDER BY Issues ASC ;