Consider a relation book (title, price) which contains the titles and prices of different books.
Assuming that no two books have the same price, what does the following SQL query list ?
Select title
from book as B
where (select count (*)
from book as T
where T.price > B.price) < 71
Titles of the six most expensive books
2
Title of the sixth most expensive books
3
Titles of the seven most expensive books
4
Title of the seventh most expensive books