Organizational Research By

Surprising Reserch Topic

Question:The titles of all the books that meet the following criteria has to be displayed:


The titles of all the books that meet the following criteria has to be displayed:

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

The result has to be sorted by the date of purchase, starting with the most recently bought book.
Which of the following statements should be used?
a.        SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date < '21-FEB-2002' ORDER BY purchase_date
b.        SELECT book_title FROM books WHERE price IN (500, 900) AND purchase_date< '21-FEB-2002' 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<'21-FEB-2002' ORDER BY purchase date DESC
Last improved on 2/2/2012 at 11:10:13 PM by Usman
asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 12, 2013
0 votes
25 views



Related Hot Questions



Government Jobs Opening


...