List all schools and their nicknames in the order of founded year.
CREATE TABLE university (school VARCHAR, nickname VARCHAR, founded VARCHAR)
SELECT school, nickname FROM university ORDER BY founded
### Context: CREATE TABLE university (school VARCHAR, nickname VARCHAR, founded VARCHAR) ### Question: List all schools and their nicknames in the order of founded year. ### Answer: SELECT school, nickname FROM university ORDER BY founded