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

Instruction

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

Exercise

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.