CREATE TABLE table_2665085_1 (park VARCHAR2, name VARCHAR2)

How many parks is Zippin Pippin located in
SELECT COUNT(park) FROM table_2665085_1 WHERE name = "Zippin Pippin"
SELECT COUNT("park") FROM "table_2665085_1" WHERE "Zippin Pippin" = "name"