Course Content
Introduction to SQL
Introduction to SQL
Challenge: Excluding A Range
As a librarian, you received a request to make a list of all the books that were published either before 1990 or after 2015.
Swipe to show code editor
Write a query to fetch the titles and publication dates of all the books that match the conditions.
The books table includes these columns: id, title, author, genre and publication_year.
Solution
Switch to desktop for real-world practiceContinue from where you are using one of the options belowThanks for your feedback!
Challenge: Excluding A Range
As a librarian, you received a request to make a list of all the books that were published either before 1990 or after 2015.
Swipe to show code editor
Write a query to fetch the titles and publication dates of all the books that match the conditions.
The books table includes these columns: id, title, author, genre and publication_year.
Solution
Switch to desktop for real-world practiceContinue from where you are using one of the options belowThanks for your feedback!
Switch to desktop for real-world practiceContinue from where you are using one of the options below