Introduction
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

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 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.

Console

Code editor

Result

TableConsole