Practice · History · Medium
Show the name, current_city and current_country of every obelisk whose original_site was Heliopolis.
Runs in your browser. No signup needed.
obelisks(name, original_site, current_city, current_country).
SELECT name, current_city, current_country
FROM obelisks
WHERE original_site = ...;The reference solution is checked automatically when you run your query on the practice page — results are compared row by row.
Ancient Heliopolis was stripped almost bare: its obelisks now stand in Rome, London, New York, Florence and Cairo. (Wikipedia, Egyptian obelisks)