Introduction
Challenge with artists

Instruction

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.

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

Console

Code editor

Result

TableConsole