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

what is the difference in attendance between november 5 and november 25
SELECT ABS((SELECT "attendance" FROM table_204_994 WHERE "date" = 'november 5') - (SELECT "attendance" FROM table_204_994 WHERE "date" = 'november 25'))
SELECT ABS((SELECT "attendance" FROM "table_204_994" WHERE "date" = 'november 5') - (SELECT "attendance" FROM "table_204_994" WHERE "date" = 'november 25'))