Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

SQL Practice Set in PostgreSQL

Introduction
Exercises with artists, museums and their pieces of art
Exercises with the band members table
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 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 an artist focused on.