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,
  • piece_of_art,
  • museum_loan.

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,
  • birth_year – the year of birth of a given artist,
  • death_year – the year of death of a given artist,
  • artistic_field – the field of art that a given artist focused on,
  • country_origin – the name of the country in which a given artist was born.