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

1. Purchased before November 11, 2002 
2. Price is less than $500 or greater than $900

You want to sort the result by the date of purchase, starting with the most recently bought book. 
Which of the following statements should you use? 

A SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date < '2002-11-11' ORDER BY purchase_date; 
B SELECT book_title FROM books WHERE price IN (500, 900) AND purchase_date< '2002-11-11' 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 price > 900) AND purchase_date < '2002-11-11' ORDER BY purchase_date DESC; 

+ Answer
D 

+ Report

Mohammad Towhidul Islam

Editor, VCampus

Your Name

Your Email

Type of Report
Spelling MistakeIncorrect AnswerGrammar MistakeContent MissingImproper Text FormatInsufficient AnswerDuplicate QuestionImproper Sentence StructureImproper Equation/FormulaOther

Description