Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

SQL Practice Set in PostgreSQL

Introduction
Exercises
5. Good orchestras that are newer than the Chamber Orchestra
Correlated Subqueries

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