Question: 2.

You want to display the titles of books that meet these criteria:

1. Purchased before January 21, 20012.

Price is less then $500 or greater than $900

You want to sort the results by their data of purchase, starting with the most recently boughtbook.

Which statement should you use?

A. SELECT book_title FROM books

WHERE price between 500 and 900

AND purchase_date < '21-JAN-2001'

ORDER BY purchase_date;

B. SELECT book_titleFROM books

WHERE price IN (500,900)

AND purchase_date < '21-JAN-2001'

ORDER BY purchase date ASC;
C. SELECT book_titleFROM books

WHERE price <> 900

AND purchase_date < '21-JAN-2001'

ORDER BY purchase date DESC;

D. SELECT book_titleFROM books

WHERE (price <> 900)

AND purchase_date < '21-JAN-2001'

ORDER BY purchase date DESC;

Answer: D
Explanation:

This statement provides required results.

Incorrect Answers:

A: This query will show books with price in range $500 and $900, not less then $500 or greater than $900.

B: This query will show books with prices exactly $500 or $900, not less then $500 or greaterthan $900.

C: This order will not show correct rows because of incorrect syntax in the WHERE clause.