Write a query to list the name
s of authors
who have written at least one book which was published either in 2010 or earlier
. 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.