CREATE TABLE table_12078626_1 (date_of_completion VARCHAR2, success VARCHAR2)

what's the date of completion where success is yes
SELECT date_of_completion FROM table_12078626_1 WHERE success = "Yes"
SELECT "date_of_completion" FROM "table_12078626_1" WHERE "Yes" = "success"