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

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

SQL Practice Set in PostgreSQL

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.