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.
