CREATE TABLE table_79214 ("Actor" CLOB, "Character" CLOB, "Soap Opera" CLOB, "Years" CLOB, "Duration" CLOB)

Which actor played Harold Bishop for 17 years?
SELECT "Actor" FROM table_79214 WHERE "Duration" = '17 years' AND "Character" = 'harold bishop'
SELECT "Actor" FROM "table_79214" WHERE "Character" = 'harold bishop' AND "Duration" = '17 years'