Get startedGet started for free

Right outer join

This time you want to figure out which tracks have never been sold. With this information eSymphony can limit the songs on offer and do some more targeted sales. They want you to focus on Miles Davis specifically because they noticed that jazz is not selling particularly well.

The company has asked you to do this by using a right outer join. Feels like they are being weirdly specific in their request but you decide to go along with it.

The data you need is spread across two tables. Here is the ERD to help you with identifying which ones:

Full Chinook dataset ER diagram

This exercise is part of the course

Introduction to Oracle SQL

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise