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
