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

Do you remember the Members table?

Exercise

Select all data from the Members table. This table contains information about a few selected members of orchestras, and consists of the following columns:

  • Id – the ID of a given member,
  • Name – the name of a given member,
  • Position – the position of a given member in an orchestra,
  • Wage – the fixed monthly payment a given musician receives,
  • Experience – the number of years of experience a given musician has,
  • OrchestraId – the ID of the orchestra in which a given musician works.