You want to display the titles of books that meet these criteria: 1. Purchased before January 21, 2001 2. Price is less then $500 or greater than $900 You want to sort the results by their data of…

The correct answer is D. SELECT book_title. 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 B: This query will show books with prices exactly $500 or $900, not less then $500 or greater C: This order will not show…

Restricting and Sorting Data

Question

You want to display the titles of books that meet these criteria: 1. Purchased before January 21, 2001 2. 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 bought book. Which statement should you use?

Options

ASELECT book_title
BSELECT book_title
CSELECT book_title
DSELECT book_title

How the community answered

(25 responses)

A
12% (3)
B
4% (1)
C
4% (1)
D
80% (20)

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 B: This query will show books with prices exactly $500 or $900, not less then $500 or greater C: This order will not show correct rows because of incorrect syntax in the WHERE clause..

Topics

#compound conditions#AND OR operators#ORDER BY DESC#date filtering

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice