On January 21th at 14:15 UTC , progression through exercises will be unavailable for 10 minutes due to a planned maintenance break.
Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close


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