How many schools are there?
select count(school) from university
Please list the years they were founded.
select founded from university
Please list their locations.
select location from university
how many of them are in NY?
select count(*) from university where location like "%ny%"