Find how many school locations have the word 'NY'.
select count(*) from university where location like "%ny%"