Introduction
Exercises

Instruction

Great! How about this one?

Exercise

Show name of the orchestras that have the same number of members as the 'Musical Orchestra'. Show the number of members in the second column.

Stuck? Here's a hint!

You will need to use JOIN in the main query as well as in the subquery inside HAVING statement.

Console

Code editor

Result

TableConsole