Practice · History · Medium
List the name, discovery_year and discoverer of finds made between 1900 and 1999 inclusive, earliest first.
Runs in your browser. No signup needed.
discoveries(name, discovery_year, discoverer).
SELECT name, discovery_year, discoverer
FROM discoveries
WHERE discovery_year BETWEEN ... AND ...
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 twentieth century produced both the most famous find (Tutankhamun, 1922) and the most disputed (the Nefertiti bust, 1912). (World History Encyclopedia; SMB Berlin)