It's Autumn! Prices fall like leaves! - hours only!Up to 80% off on all courses and bundles.-Close
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.