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?
FROM Book AS B
WHERE (SELECT COUNT(*))
FROM Book AS T
WHERE T.price>B.price <5
Please provide an explanation also
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