CREATE TABLE university (LOCATION VARCHAR)

Find how many school locations have the word 'NY'.
SELECT COUNT(*) FROM university WHERE LOCATION LIKE "%NY%"
SELECT COUNT(*) FROM "university" WHERE "LOCATION" LIKE "%NY%"