CREATE TABLE table_203_754 (id NUMBER, "no." NUMBER, "player" CLOB, "position" CLOB, "career" CLOB, "date no. retired" CLOB)

what numbers were retired before 1989 ?
SELECT "no." FROM table_203_754 WHERE "date no. retired" < 1989
SELECT "no." FROM "table_203_754" WHERE "date no. retired" < 1989