Governorates with no listed site (anti-join)

What you are given

LEFT JOIN governorates → unesco_sites on name = governorate, then keep only rows WHERE the site is NULL. This “anti-join” finds the gaps.

Starting point

SELECT g.name
FROM governorates g
LEFT JOIN unesco_sites u ON g.name = u.governorate
WHERE u.site IS NULL
ORDER BY g.name;

The reference solution is checked automatically when you run your query on the practice page — results are compared row by row, and order matters for this one.

Did you know

The LEFT-JOIN-then-IS-NULL pattern is the standard way to ask “what’s missing?” — finding the absence of a match. (SQLite docs)

More Demographics challenges

• The most populous governorates Easy
• Population density Medium
• Egypt’s total population Easy
• Bigger than average Hard
• Egypt since the millennium Easy

Open it in the playground →