Explanation:
This statement provides required results.
Incorrect Answers:
1: This query will show books with price in range $500 and $900, not less then $500 or greater than $900.
2: This query will show books with prices exactly $500 or $900, not less then $500 or greater than $900.
3: This order will not show correct rows because of incorrect syntax in the WHERE clause.
OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 56-66
Chapter 2: Limiting, Sorting, and Manipulating Return Data

---