Practice · Education · Medium
Return the name and age (2026 − founded) of every university more than 100 years old, oldest first.
Runs in your browser. No signup needed.
universities(name, founded). Compute 2026 − founded and filter WHERE it is greater than 100.
SELECT name, 2026 - founded AS age
FROM universities
WHERE 2026 - founded > 100
ORDER BY age DESC;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.
Al-Azhar has taught since 970 CE — over a thousand years — making it one of the oldest continuously operating universities on Earth. (Britannica)