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

undefined XP
  • 1

    Select the Title column from the Album table.

  • 2

    Select the LastName from the Customer table.

  • 3

    Select the LastName and Country from the Customer table.