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 MS SQL Server

Introduction
Challenge with artists

Instruction

The third table in this set is the PieceOfArt table. This provides us with information about the artwork of all relevant artists.

Exercise

Select all data from the PieceOfArt table.

As you can see it has these four columns:

  • Id – the ID of a given piece of art,
  • Name – the name of a given piece of art,
  • ArtistId – the ID of the artist who created a given piece of art,
  • MuseumId – the ID of the museum that houses a given piece of art in its collection.