Practice · History · Easy
List the name and current_city of every obelisk that still stands in Egypt.
Runs in your browser. No signup needed.
obelisks(name, pharaoh, original_site, current_city, current_country, height_m, year_moved).
SELECT name, current_city
FROM obelisks
WHERE current_country = ...;The reference solution is checked automatically when you run your query on the practice page — results are compared row by row.
Only about half the surviving ancient Egyptian obelisks are still in Egypt — the rest were carried off, mostly to Rome. (Wikipedia, Egyptian obelisks)