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 Concerts table?

Exercise

Select all data from the Concerts table. It has the following six columns:

  • Id – the ID of a given concert,
  • City – the name of the city where a given concert took place,
  • Country – the name of the country where a given concert took place,
  • Year – the year in which a given concert was held,
  • Rating – the average rating (by critics) of a given concert,
  • OrchestraId – the ID of the orchestra that performed at a given concert.