Introduction
Exercises

Instruction

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

Exercise

Show the name and number of members for each orchestra that has more members than the average membership of all orchestras in the table.

Stuck? Here's a hint!

You will need to nest subqueries. In the HAVING statement you'll need a subquery counting average of members in orchestras – which you will get from another subquery.

Console

Code editor

Result

TableConsole