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 its name, the name of a country, the number of concerts performed by a given orchestra in this particular country and the average rating received in this country by this orchestra.

Consider only these orchestras that performed 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.