Your first SELECT

What you are given

pharaohs(name, dynasty, reign_start, reign_end, era). Just pick two columns — no filter needed.

Starting point

SELECT name, era
FROM pharaohs;

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

Did you know

SELECT is the verb behind every question you will ever ask a database. Everything else just refines it. (SQLite docs)

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 →