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 writers of the books in ascending alphabetical order.
assistant
SELECT Writer FROM book ORDER BY Writer ASC
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
How many books are there?
assistant
SELECT count(*) FROM book
human
What are the titles of the books whose writer is not 'Elaine Lee'?
assistant
SELECT Title FROM book WHERE Writer != 'Elaine Lee'
human
List the titles of the books in ascending order of issues.
assistant
SELECT Title FROM book ORDER BY Issues ASC
human
What are the title and issues of the books?
assistant
SELECT Title , Issues FROM book ;