Get startedGet started for free

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.

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 WorldBankRegion,
       CountryName,
       ___ -- Capital city name column
FROM Nations
WHERE Capital NOT IN
	(SELECT ___ -- City name column
     FROM Earthquakes);
Edit and Run Code