CREATE TABLE table_203_248 (id NUMBER, "code" CLOB, "year" NUMBER)

is the e code less than 1950 ?
SELECT (SELECT "year" FROM table_203_248 WHERE "code" = 'e') < 1950
SELECT (SELECT "year" FROM "table_203_248" WHERE "code" = 'e') < 1950