Consider a relation book(title,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) < 7
a) Titles of the six most expensive books
b) Titles of the sixth most expensive book
c) Titles of the seven most expensive books
d) Titles of the seventh most expensive book
How the inner Query works?