CREATE TABLE table_204_994 (id NUMBER, "date" CLOB, "time" CLOB, "opponent#" CLOB, "rank#" CLOB, "site" CLOB, "tv" CLOB, "result" CLOB, "attendance" NUMBER)

how many wins did they have before the november 19th game ?
SELECT COUNT(*) FROM table_204_994 WHERE "result" = 'w' AND id < (SELECT id FROM table_204_994 WHERE "date" = 'november 19')
SELECT COUNT(*) FROM "table_204_994" WHERE "id" < (SELECT "id" FROM "table_204_994" WHERE "date" = 'november 19') AND "result" = 'w'