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