1. Uczyć się
    2. /
  2. Courses
    3. /
  3. Introduction to Oracle SQL
Connected

Exercise

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

Instrukcje 1 / 3

undefined XP
    1
    2
    3

Pytanie

What tables do you need?

Możliwe odpowiedzi