Introduction
Challenge with artists

Instruction

Good. Here is the last one from this section.

Exercise

Show the ID of each museum (as museum_id), along with the year in which it loaned the greatest amount of artwork of all the years in which it has been loaning artwork. As a third column show the number of loaned pieces, and name the column number_loaned. Consider only those years in which this museum loaned more than one piece of art.

Console

Code editor

Result

TableConsole