Governorates without a university (EXCEPT)

What you are given

SELECT name FROM governorates EXCEPT SELECT city FROM universities. EXCEPT subtracts the second set from the first.

Starting point

SELECT name FROM governorates
EXCEPT
SELECT city FROM universities
ORDER BY 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

EXCEPT (called MINUS in some databases) answers “in A but not in B” — a clean alternative to an anti-join for single columns. (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 →