New Kingdom monuments only

What you are given

monuments JOIN pharaohs on builder = name, then filter WHERE the pharaoh’s era = ‘New Kingdom’.

Starting point

SELECT m.name
FROM monuments m
JOIN pharaohs p ON m.builder = p.name
WHERE p.era = 'New Kingdom'
ORDER BY m.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

The New Kingdom (Dyn. XVIII–XX) was Egypt at its imperial height — the era of Hatshepsut, Tutankhamun and Ramesses II. (Oxford History of Ancient Egypt)

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 →