Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
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 in a given country. Order the results by the number of pieces in descending order, the name of an artist in ascending order, and the name of a country in ascending order.

Stuck? Here's a hint!

You will need three columns:

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

You have to use three tables in this exercise: piece_of_art, museum, and artist.