CREATE TABLE table_name_42 (interview_subject VARCHAR2, date VARCHAR2)

What Interview subject was on a Date that is 11-92?
SELECT interview_subject FROM table_name_42 WHERE date = "11-92"
SELECT "interview_subject" FROM "table_name_42" WHERE "11-92" = "date"