Best April 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 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 concerts_no column.
  • Average rating of the concerts played by this orchestra in this country as the avg_rating 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.