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 MS SQL Server

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 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.