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

Instruction

Welcome to the next part of the challenge! As in the previous part, you've already worked with three out of four of the tables here, so this will serve as a quick refresher.

Exercise

Select all data from the Orchestras table. As you can see, it consists of the following columns:

  • Id – the ID of a given orchestra,
  • Name – the name of a given orchestra,
  • MembersNumber – the total number of members of a given orchestra,
  • Rating – the average rating of a given orchestra over the last ten years,
  • CityOrigin – the city from which a given orchestra originates,
  • CountryOrigin – the country of origin of a given orchestra,
  • YearOrigin – year in which a given orchestra was created.