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

Great! How about this one?

Exercise

For each orchestra show the Name of the orchestra, the name of the City where the orchestra received the highest rating for its performance, and the Rating.

Stuck? Here's a hint!

Use correlated subqueries. In the subquery select the highest rating received by the orchestra. Use the subquery in WHERE to filter concerts when the orchestra was given this rating.