CREATE TABLE table_202_205 (id NUMBER, "year" CLOB, "title" CLOB, "role" CLOB, "notes" CLOB)

which year did he play the role of mac harper and also pat trammell ?
SELECT "year" FROM table_202_205 WHERE "role" = 'mac harper'
SELECT "year" FROM "table_202_205" WHERE "role" = 'mac harper'