Practice · Education · Easy
Return the name and founded year of the universities founded in exactly 1908, 1919, or 1950, oldest first.
Runs in your browser. No signup needed.
universities(name, founded). Use WHERE founded IN (…).
SELECT name, founded
FROM universities
WHERE founded IN (1908, 1919, 1950)
ORDER BY founded;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.
IN is shorthand for several OR conditions — cleaner and easier to read. (SQLite docs)