Exercises

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

คำแนะนำ 1 / 3

undefined XP

1

2

3

คำถาม

What tables do you need?

คำตอบที่เป็นไปได้

Track, Invoice, Customer

Customer, Invoice, InvoiceLine

Track, Invoice, InvoiceLine

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercises

คำแนะนำ 1 / 3

คำถาม

คำตอบที่เป็นไปได้

Exercises