Exploring classic rock songs - AND/OR
Having familiarized yourself with the songlist table, you'll now extend your WHERE clause from the previous exercise.
Latihan ini adalah bagian dari kursus
Introduction to SQL Server
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
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;