Introduction
Exercises

Instruction

Cool! Here comes the next one!

Exercise

Show all information for orchestras that were created after the 'Chamber Orchestra' and have a rating greater than 7.5.

Stuck? Here's a hint!

In order to get information about the orchestras created after the 'Chamber Orchestra', you need to compare the year column with the subquery in the WHERE clause. If you want to check the ratings of such orchestras and show only those that have a rating greater than 7.5, you need to add an additional condition outside of the subquery:

AND rating > 7.5

Console

Code editor

Result

TableConsole