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:
This exercise is part of the course
Introduction to Oracle SQL
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
