Practice · History · Medium
List the name, current_city, current_country and height_m of every obelisk standing outside Egypt, tallest first.
Runs in your browser. No signup needed.
obelisks(name, current_city, current_country, height_m). Use <> (or !=) to exclude Egypt.
SELECT name, current_city, current_country, height_m
FROM obelisks
WHERE current_country <> ...
ORDER BY ...;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.
The tallest standing Egyptian obelisk in the world is not in Egypt — it is the Lateran Obelisk in Rome, at 32.18 m. (Wikipedia, Egyptian obelisks)