CREATE TABLE table_204_523 (id NUMBER, "week" NUMBER, "date" CLOB, "opponent" CLOB, "score" CLOB, "result" CLOB, "attendance" NUMBER, "record" CLOB)

what is the difference between the number of games won and the number of games lost ?
SELECT ABS((SELECT COUNT(*) FROM table_204_523 WHERE "result" = 'win') - (SELECT COUNT(*) FROM table_204_523 WHERE "result" = 'loss'))
WITH "_u_0" AS (SELECT COUNT(*), 'win' AS "_u_1" FROM "table_204_523" GROUP BY 'win'), "_u_2" AS (SELECT COUNT(*), 'loss' AS "_u_3" FROM "table_204_523" GROUP BY 'loss') SELECT ABS(COALESCE("_u_0"."", *) - COALESCE("_u_2"."", *)) LEFT JOIN "_u_0" "_u_0" ON "_u_0"."_u_1" = "result" LEFT JOIN "_u_2" "_u_2" ON "_u_2"."_u_3" = "result"