Exploring classic rock songs - AND/OR
Having familiarized yourself with the songlist table, you'll now extend your WHERE clause from the previous exercise.
Questo esercizio fa parte del corso
Introduction to SQL Server
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
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;