CREATE TABLE table_204_948 (id DECIMAL, "year" DECIMAL, "award" TEXT, "category" TEXT, "film" TEXT, "result" TEXT)

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