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
Exercises

Instruction

Very good! Now try a very similar exercise!

Exercise

Show the names of the most experienced members of each orchestra and the name of that orchestra. Rename the columns to Member and Orchestra, respectively.

Stuck? Here's a hint!

In the subquery, select the maximal experience among all members coming from the orchestra as the member in the outer query. Use the = operator to select members with the same experience.