Exercise

Joining multiple tables

This time around eSymphony wants to know what tracks were bought the most in the USA. With this information they can help understand the demographics in this country and set up a marketing campaign.

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

Full Chinook dataset ER diagram

Instructions 1/3

undefined XP

1

2

3

Question

What tables do you need?

Possible answers

Track, Invoice, Customer

Customer, Invoice, InvoiceLine

Track, Invoice, InvoiceLine