Title: Based upon the contents of the BOOKS table in the accompanying figure, which of the following ... Post by: Cynh972 on Jan 31, 2018 Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will return the category and title of all books stored in the BOOKS table presented in order of their category and, for the books in the same category, sort the title of the books in descending order?
a. SELECT category, title FROM booksORDERED BY 1, 2 DESC; b. SELECT category, title FROM booksORDER BY 1 ASC, 2 DESC; c. SELECT category, title FROM booksSORTED BY 1 ASC, 2 DESC; d. SELECT category, title FROM booksSORT BY 1, 2 DESC; Title: Based upon the contents of the BOOKS table in the accompanying figure, which of the following ... Post by: cedd123 on Jan 31, 2018 Content hidden
|