CREATE TABLE table_name_55 (year VARCHAR2, role VARCHAR2)

In what Year is there a Role of (cameo)?
SELECT year FROM table_name_55 WHERE role = "(cameo)"
SELECT "year" FROM "table_name_55" WHERE "(cameo)" = "role"