Show me the location details
select location from university
Show me the details of the schools
select school from university
Show me how many school locations have the word 'NY'
select count ( * ) from university where location like "%ny%"