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

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

SQL Practice Set in PostgreSQL

Introduction
Exercises
8. The average number of members in orchestra
Correlated Subqueries

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.