Exercises with artist, museums and their pieces of art
2. Get to know the artist table
Exercises with the band members table
Exercises with tables of Japanese 100 Yen store
Exercises with employees, salaries and benefits


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.


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 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 an artist focused on.


Code editor