Challenge: Negating a Range
In the previous task, you had received a request to make a list of all the books that were published either before 1990 or after 2015.
Task
Swipe to start coding
You had to write a query to fetch the titles and publication dates of all the books that match the conditions.
The solution for the previous task involved the usage of the OR
operator.
Now your task is to rewrite the same query, however this time without the OR
operator.
The books
table includes these columns: id
, title
, author
, genre
and publication_year
.
Solution
Everything was clear?
Thanks for your feedback!
SectionΒ 2. ChapterΒ 16