Practice · History · Easy
List the name and discovery_year of every find made before 1950, earliest first.
Runs in your browser. No signup needed.
discoveries(name, discovery_year, discoverer, site).
SELECT name, discovery_year
FROM discoveries
WHERE discovery_year < ...
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.
The Tanis royal tombs were found intact in 1939-40 — and then almost entirely ignored, because the Second World War broke out weeks later. (Wikipedia, Tanis)