Introduction
2. Get to know the orchestras table

Instruction

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!

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,
  • 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.

Console

Code editor

Result

TableConsole