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


Very good! Now try a very similar 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.