CREATE TABLE table_name_7 (result VARCHAR2, year NUMBER)

What were the results before the year 2000?
SELECT result FROM table_name_7 WHERE year < 2000
SELECT "result" FROM "table_name_7" WHERE "year" < 2000