6. How many pieces does each museum have?
7. Where are the works of each artist located?
Great! How about this one?
For all ratings received by each orchestra, show the name of the orchestra, the name of the city where the orchestra received the highest rating for its performance, and the rating.