Introduction
3. Get to know the concerts table

Instruction

Good! But what would an orchestra be without a concert?

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 performed,
  • rating – the average rating (by critics) of a given concert,
  • orchestra_id – the id of the orchestra that performed at a given concert.

Console

Code editor

Result

TableConsole