Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Exercises

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