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
6. Orchestras from cities visited in 2013
Correlated Subqueries

Instruction

Good job! Here comes the next one!

Exercise

Select the names of all orchestras that have the same city of origin as any city in which there was a concert in 2013.

Stuck? Here's a hint!

You can use the IN keyword:

WHERE city_origin IN (...)

In the subquery select cities in which there was a concert in 2013.