CREATE TABLE table_203_762 (id NUMBER, "#" NUMBER, "date" CLOB, "film" CLOB, "gross" CLOB, "notes" CLOB)

what was the previous film to air before collateral damage ?
SELECT "film" FROM table_203_762 WHERE "date" < (SELECT "date" FROM table_203_762 WHERE "film" = 'collateral damage') ORDER BY "date" DESC LIMIT 1
SELECT "film" FROM "table_203_762" WHERE "date" < (SELECT "date" FROM "table_203_762" WHERE "film" = 'collateral damage') ORDER BY "date" DESC FETCH FIRST 1 ROWS ONLY