Session Ready
Exercise

Inner Joins - a perfect match

Let's use the Chinook database, which consists of tables related to an online store, to understand how inner joins work. The album table lists albums by multiple artists. The track table lists individual songs, each with a unique identifier, but also, an album_id column that links each track to an album.

Let's find the tracks that belong to each album.

Instructions
100 XP
  • Perform an inner join between album and track using the album_id column.