datacamp-logo
Course Outline
BETA
Exercise

Writing your first query

The ERD you saw in the video is part of a digital media store's data model offering services similar to iTunes. The company is called eSymphony. It includes tables for artists, albums, media tracks, invoices, and customers.

Let's start exploring the data! In this exercise, you will use SELECT statements to show the relevant columns from a database table.

Instructions 1/3
XP
  • 1

    Select the Title column from the Album table.

      Take Hint (-10 XP)
  • 2

    Select the LastName from the Customer table.

  • 3

    Select the LastName and Country from the Customer table.