Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
2. Get to know the orchestras table


Before we can start querying, we first have to get to know our newest set of tables. Let's start with the smallest one, the orchestras table. Note that the data in these tables are made up and any resemblance to real names of musicians and orchestras is purely coincidental!


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,
  • rating – the average rating of a given orchestra over the last ten years,
  • city_origin – the city from which a given orchestra originates.
  • country_origin – the country of origin of a given orchestra,
  • year – year in which a given the orchestra was created.