Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
8. The average number of members in orchestra
Correlated Subqueries


You're unstoppable! Are you ready for the next one?


Find the average number of members of all orchestras in the table.

Remember this query. You'll need it in the next exercise!

Stuck? Here's a hint!

In the subquery find the number of members in each orchestra. Put the subquery in the FROM clause. (Remember to give your subquery an alias.)

In the outer query compute the average membership of all orchestras, using the results of your subquery.