You want to display the titles of books that meet these criteria: 1. Purchased before January 21, 2001 2. Price is less than $ 500 or greater than $ 900 You want to sort the result by their date of purchase, starting with the most recently bought book. Which statement should you use? | Oracle

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_title FROM books WHERE price IN (500, 900) AND purchase_date< '21- jan-2001' ORDER BY purchase date ASC;
C. SELECT book_title FROM books WHERE price < 500 OR>900 AND purchase_date DESC;
D. SELECT Book_title FROM books WHERE price < 500 OR>900 AND purchase_date<'21-JAN-2001' ORDER BY purchase date DESC;
E. SELECT book_title FROM books WHERE (price< 500 OR price> 900) AND purchase date> '21 - JAN-2001' ORDER BY purchase date ASC;

Ans:D