Introduction
Challenge with orchestras

Instruction

Well done! Another one?

Exercise

For each instrument show its type, maker, current owner's name, the corresponding orchestra name, and the number of concerts (name that columns as concert_number) the owner might have played on this instrument from 2013 to 2016. Take into consideration only instruments produced in 2013 or earlier.

Stuck? Here's a hint!

In order to count the number of concerts you should create a subquery in the SELECT clause.

Console

Code editor

Result

TableConsole