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

Here comes the new table!

Exercise

Select all data from the Instruments table. It contains information about instruments owned by the musicians that are members of a given orchestra. The instruments table consists of the following columns:

  • Id – the ID of a given instrument,
  • OwnerId – the ID of the owner of a given instrument,
  • Type – the type of a given instrument,
  • Maker – the name of a given instrument's manufacturer or creator,
  • ProductionYear – the year in which a given instrument was produced,
  • Value – the approximate value of a given instrument.