Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Challenge with orchestras


All right, give this one a go!


For each orchestra, show a report consisting of:

  • Name of the orchestra as the Name column.
  • Country/Countries in which the orchestra played as the Country column.
  • Number of concerts in this country as the ConcertsNo column.
  • Average rating of the concerts played by this orchestra in this country as the AvgRating column.

Show only the rows of the report for which the orchestra played more than once in a given country.

Stuck? Here's a hint!

You need to join tables Orchestras and Concerts. Group by the name of the orchestra and the name of the country where the concert took place. Use HAVING to filter countries where the orchestra performed more than once.