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.

Console

Code editor

Result

TableConsole