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

Instruction

We have artists, we have museums... something is missing. That's right! The pieces of art themselves!

Exercise

Select all data from the piece_of_art table.

As you can see it has four columns:

  • id – the id of a given piece of art,
  • name – the name of a given piece of art,
  • artist_id – the id of the artist that created a given piece of art,
  • museum_id – the id of the museum that has a given piece of art in its collection.

Console

Code editor

Result

TableConsole