Royal women and their roles

What you are given

royal_women(name, dynasty, period_start, period_end, role). Years are signed (negative = BCE).

Starting point

SELECT name, role
FROM royal_women;

The reference solution is checked automatically when you run your query on the practice page — results are compared row by row.

Did you know

Hatshepsut began as regent for her stepson Thutmose III and then took the full titulary of pharaoh — not a consort, a king. (Wikipedia, Hatshepsut)

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 →