CREATE TABLE table_name_8 (type VARCHAR2, location VARCHAR2)

What type of bridge is in Cooperstown?
SELECT type FROM table_name_8 WHERE location = "cooperstown"
SELECT "type" FROM "table_name_8" WHERE "cooperstown" = "location"