CREATE TABLE table_275162_1 (course VARCHAR2, location VARCHAR2)

How many courses are located in carmel, indiana?
SELECT COUNT(course) FROM table_275162_1 WHERE location = "Carmel, Indiana"
SELECT COUNT("course") FROM "table_275162_1" WHERE "Carmel, Indiana" = "location"