Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Exercises with artists, museums and their pieces of art
2. Get to know the Artist table
Exercises with the band members table
Exercises with employees, salaries and benefits

Instruction

As you may have guessed, we're about to introduce a new dataset for this part. Today we'll be working with three tables. The first one is the Artist table.

Exercise

Select all data from the Artist table. It consists of the following columns:

  • Id – the id of a given artist,
  • Name – the name of a given artist,
  • BirthYear – the year of birth of a given artist,
  • DeathYear – the year of death of a given artist,
  • ArtisticField – the field of art that an artist focused on.