Uncorrelated sub-query
A sub-query is another query within a query. The sub-query returns its results to an outer query to be processed.
You want a query that returns the region and countries that have experienced earthquakes centered at a depth of 400km or deeper. Your query will use the Earthquakes table in the sub-query, and Nations table in the outer query.
This exercise is part of the course
Improving Query Performance in SQL Server
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT UNStatisticalRegion,
CountryName
FROM Nations
WHERE ___ -- Country code for outer query
IN (SELECT ___ -- Country code for sub-query
FROM Earthquakes
WHERE ___ >= ___ ) -- Depth filter
ORDER BY UNStatisticalRegion;