Practice · History · Medium
Count the temples in each period. Return period and a column named temples, most first, breaking ties by period name.
Runs in your browser. No signup needed.
temples(period). Periods include New Kingdom, Ptolemaic and later mixes.
SELECT period, COUNT(*) AS temples
FROM temples
GROUP BY ...
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.
Many of Egypt’s best-preserved temples are the youngest: Edfu and Dendera are Ptolemaic, built while Rome was rising. (Touropia; Wikipedia)