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
