question archive 1) Display the title and publication date of books published after 1-Jan-2001
1) Display the title and publication date of books published after 1-Jan-2001
Subject:Computer SciencePrice:2.84 Bought7
1) Display the title and publication date of books published after 1-Jan-2001. Use the following column headings: "Book Title", and "Publication Date". Order the result by title in ascending order and then by publication date in descending order. Use the column aliases in the ORDER BY clause to identify the sort columns.
Purchase A New Answer
Custom new solution created by our subject matter experts
GET A QUOTE
Answer Preview
SELECT BOOK_TITLE, PUBLISHING_DATE
FROM BOOK
WHERE PUBLISHING_DATE > '2001/01/01'
ORDER BY BOOK_TITLE ASC, PUBLISHING_DATE DESC;
Step-by-step explanation
Please find answer in the above section.
