Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
5. Good orchestras that are newer than the Chamber Orchestra
Correlated Subqueries


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


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