Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
3. Get to know the concerts table


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


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.