Let's practice! - WHERE

In this set of exercises, you'll use the songlist table, which contains songs featured on the playlists of 25 classic rock radio stations.

• Yes

• OK, let go!

• Retrieve the song, artist, and release_year columns from the songlist table.

• Make sure there are no NULL values in the release_year column.

• Fill in the blank

• Order the results by artist and release_year.

• SELECT song, artist, release_year FROM songlist WHERE release_year IS NOT NULL

  ______;

• Fill in the blank

• Extend the WHERE clause so that the results are those with a release_year greater than or equal to 1980 and less than or equal to 1990.

• SELECT song, artist, release_year FROM songlist WHERE ______

• ORDER BY artist, release_year;

• Fill in the blank

• Select all artists beginning with B who released tracks in 1986, but also retrieve any records where the release_year is greater than 1990.

• SELECT song, artist, release_year FROM songlist WHERE ______

• ORDER BY artist, release_year;

• ^{(artist = 'B%' AND release_year = 1986)}

  ^{OR release_year > 1990}

• ^{artist LIKE 'B%' AND release_year = 1986}

  ^{OR release_year > 1990}

• ^{(artist LIKE 'B%' AND release_year = 1986)}

  ^{OR release_year > 1990}

• ^{(artist LIKE 'B%' AND release_year = 1986)}

  ^{AND release_year > 1990}