Which one is the the newest school?
select school from university order by founded desc limit 1
Among the schools, which ones were founded before 1800?
select school from university where founded < 1800
Can you list the school names ordered by year founded in decreasing order?
select school from university order by founded desc
Please give the year that the first non public school was founded.
select founded from university where affiliation != 'Public' order by founded desc limit 1