How many universities have a location that contains NY?
SELECT count(*) FROM university WHERE LOCATION LIKE "%NY%"
contains NY in location refers to LOCATION LIKE '%NY%'; how many universities refers to COUNT(*)