CREATE TABLE table_204_147 (id NUMBER, "#" NUMBER, "date" CLOB, "opponent" CLOB, "score" CLOB, "win" CLOB, "loss" CLOB, "save" CLOB, "attendance" NUMBER, "record" CLOB)

what was the difference in attendance between the july 7th game and the july 8th game ?
SELECT ABS((SELECT "attendance" FROM table_204_147 WHERE "date" = 'july 7') - (SELECT "attendance" FROM table_204_147 WHERE "date" = 'july 8'))
SELECT ABS((SELECT "attendance" FROM "table_204_147" WHERE "date" = 'july 7') - (SELECT "attendance" FROM "table_204_147" WHERE "date" = 'july 8'))