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

Well, that was a piece of cake. Moving on!

Exercise

Show the total number of pieces of art of a given artist that are displayed in a given country. Show three columns:

  • Country,
  • artist's Name,
  • total number of pieces of that artist in a given country.

Stuck? Here's a hint!

You have to use three tables in this exercise: PieceOfArt, Museum, and Artist.