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;
b
You might also like to view...
Dividend reinvestment plans should be avoided because of their relatively high cost.
Answer the following statement true (T) or false (F)
Which of the following types of advertising timing patterns calls for spending all the advertising dollars in a single period?
A) frequency capping B) flighting C) concentration D) pulsing E) continuity
Marketers describe the way a consumer processes information to arrive at brand choices as ________
A) alternative evaluation B) information search C) impulse buying D) consumer capitalism E) cognitive dissonance
The purpose of your résumé is to
A) show your creativity and problem-solving capabilities. B) focus on your skills, references, and education. C) help you network to identify open positions. D) get you an interview.