Obelisks moved in the modern era

What you are given

obelisks(name, current_city, year_moved). year_moved is NULL when the obelisk was not relocated in a recorded year.

Starting point

SELECT name, current_city, year_moved
FROM obelisks
WHERE year_moved > ...
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.

Did you know

Egypt is still moving obelisks: a Ramesses II obelisk from Tanis was re-erected in Cairo’s Tahrir Square in 2020. (Wikipedia, Egyptian obelisks)

More History challenges

• New Kingdom pharaohs Easy
• The five longest reigns Easy
• Pharaohs per era Medium
• Monuments and their builder’s dynasty Hard
• Rulers who reigned over 30 years Medium

Open it in the playground →