CREATE TABLE table_204_398 (id NUMBER, "title" CLOB, "year" NUMBER, "publisher" CLOB, "developer" CLOB, "platforms" CLOB)

number of official middle earth video games before the year 2000 .
SELECT COUNT("title") FROM table_204_398 WHERE "year" < 2000
SELECT COUNT("title") FROM "table_204_398" WHERE "year" < 2000