Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
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