Write a query to list the name
s of books
for which the next volume was published within 1 year of their publishing year
. Set the header for the single column of results, to be name
.
Note:
Even if you find other ways of doing it, try doing it using EXISTS operator in a subquery, just for the sake of your better understanding of the topic.