NOT IN with IS NOT NULL
You want to know which country capitals have never been the closest city to recorded earthquakes. You decide to use NOT IN to compare Capital from the Nations table, in the outer query, with NearestPop, from the Earthquakes table, in a sub-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 WorldBankRegion,
CountryName,
___ -- Capital city name column
FROM Nations
WHERE Capital NOT IN
(SELECT ___ -- City name column
FROM Earthquakes);