Get startedGet started for free

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

View Course

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;
Edit and Run Code