Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Challenge with artists


In this section, we'll work with four tables. You've encountered three of them before, so this will serve as a quick refresher.

  • Artist,
  • Museum,
  • PieceOfArt,
  • MuseumLoan.

Let's get started with the Artist table.


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 a given artist focused on,
  • CountryOrigin – the name of the country in which a given artist was born.