Exploring classic rock songs - AND/OR
Having familiarized yourself with the songlist table, you'll now extend your WHERE clause from the previous exercise.
This exercise is part of the course
Introduction to SQL Server
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT
song,
artist,
release_year
FROM
songlist
WHERE
-- Retrieve records greater than and including 1980
release_year ___ ___
-- Also retrieve records up to and including 1990
___ release_year ___ ___
ORDER BY
artist,
release_year;