Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Exercises
7. Same number of members as the Musical Orchestra
Correlated Subqueries

Instruction

Great! How about this one?

Exercise

Show the name of the orchestras that have the same number of members as the 'Musical Orchestra'. Show the number of members in the second column. Name the second column members_count.

Stuck? Here's a hint!

First, write a subquery that computes the number of members in the 'Musical Orchestra'. Next, write the outer query which selects the name and the number of members in each orchestra. Finally, use a subquery inside the HAVING statement of the outer query to filter orchestras which have the same number of members as the 'Musical Orchestra'.