Autumn Offers - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Exercises
5. Good orchestras that are newer than the Chamber Orchestra
Correlated Subqueries

Instruction

Good job! Now, let's start with our subqueries!

Exercise

Show the names of orchestras that were created after the 'Chamber Orchestra' and have a rating greater than 7.5.

Stuck? Here's a hint!

First, write a subquery that selects the creation year of the 'Chamber Orchestra'. Next, compare the year column with the subquery in the WHERE clause.

WHERE year > (SELECT year ...)

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