SQL query output


#1

Suppose that the relation Book(title,price) contains the titles and prices of different books.
Assuming that no two books have the same price,What is the output of the following SQL query?

SELECT title
FROM Book AS B
WHERE (SELECT COUNT(*))
FROM Book AS T
WHERE T.price>B.price <5

Please provide an explanation also
Options:
A) Titles of the four most expensive books
B)Titles of the fifth most inexpensive book
C)Titles of the fifth most expensive book
D)Titles of the five most expensive books


#2

We must have a table for this question. Is there any table provided in this question?