1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Oracle SQL

Exercise

Testing if a value is NULL

eSymphony is interested in knowing the number of tracks that are not in a playlist and cost $1.99. Since they know songs in a playlist are bought more often, they want to get an idea of the potential revenue they are missing out on.

To answer this question you will need to join the data and look at the NULL values added where the join condition is not met.

Instructions

100 XP
  • Select the total count of resulting rows.
  • Perform the appropriate join between the Track and PlaylistTrack tables.
  • Filter on tracks that are not in a playlist and cost $1.99.