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

Instruction

All right, give this one a go!

Exercise

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.