Practice · History · Medium
Count obelisks by original_site. Return original_site and a column named obelisks, most first, breaking ties by site name.
Runs in your browser. No signup needed.
obelisks(original_site).
SELECT original_site, COUNT(*) AS obelisks
FROM obelisks
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.
Heliopolis and Karnak supplied most of the obelisks that later travelled — both were vast temple precincts of the sun and of Amun. (Wikipedia, Egyptian obelisks)