Get startedGet started for free

EXCEPT

EXCEPT does the opposite of INTERSECT. It is used to check if data, present in one table, is absent in another.

You want to know which countries have no recorded earthquakes. You can get this information by comparing the Nations table with the Earthquakes table.

This exercise is part of the course

Improving Query Performance in SQL Server

View Course

Exercise instructions

  • Add the country code column from the Nations table.
  • Add the operator that compares the two queries.
  • Add the table with country codes to the right query.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

SELECT ___ -- Add the country code column
FROM Nations

___ -- Add the operator to compare the two queries

SELECT Country 
FROM ___; -- Table with country codes
Edit and Run Code