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
Exercises with artists, museums and their pieces of art
8. Legacy of unknown artists
Exercises with the band members table
Exercises with employees, salaries and benefits

Instruction

Great! Don't give up!

Exercise

Check whether there are any pieces that were created by unknown artists. Show the names of these pieces together with the names of the museums that house the pieces in their collections.

Stuck? Here's a hint!

Unknown artists have a NULL entry under ArtistId. Remember, you can use the operator IS NULL to filter the appropriate rows:

... ArtistId IS NULL