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.
Diese Übung ist Teil des Kurses
Improving Query Performance in SQL Server
Interaktive Übung
Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.
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;