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

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_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 a given artist focused on,
  • country_origin – the name of the country in which a given artist was born.