Practice · History · Hard
For each monument, show the monument name, who built it, and that builder’s dynasty — by joining monuments to pharaohs. Order by the monument’s construction_start (oldest first).
Runs in your browser. No signup needed.
monuments(name, builder, location, construction_start). pharaohs(name, dynasty). Join monuments.builder = pharaohs.name.
SELECT m.name, m.builder, p.dynasty
FROM monuments m
JOIN pharaohs p ON ...
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 Great Sphinx and Khafre’s pyramid share a builder and a site (Giza) — the Sphinx’s face is widely thought to be Khafre’s. (Britannica)