Exercise

Diagnosing problems using anti-join

Another powerful join in SQL is the anti-join. It is particularly useful in identifying which records are causing an incorrect number of records to appear in join queries.

You will also see another example of a subquery here, as you saw in the first exercise on semi-joins. Your goal is to identify the currencies used in Oceanian countries!

Instructions 1/3

35 XP

1
2
3

Begin by determining the number of countries in countries that are listed in Oceania using SELECT, FROM, and WHERE.

Take Hint (-10 XP)