Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
Challenge with orchestras


Well done! Another one?


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.