Practice · History · Medium
List the name, current_city and height_m of every obelisk attributed solely to Ramesses II, tallest first.
Runs in your browser. No signup needed.
obelisks(name, pharaoh, current_city, height_m). Some obelisks carry a shared attribution such as 'Seti I / Ramesses II'.
SELECT name, current_city, height_m
FROM obelisks
WHERE pharaoh = ...
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.
Ramesses II raised more surviving obelisks than any other pharaoh — and also re-inscribed monuments raised by his predecessors. (Wikipedia, Egyptian obelisks)