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 MS SQL Server

Introduction
Challenge with orchestras

Instruction

Let's begin with something easy.

Exercise

For each member of the orchestra who has an instrument show their Name and the average price (Value) they paid for all of their instruments.

Stuck? Here's a hint!

You need to join tables Member and Instruments, and use the GROUP BY.