CREATE TABLE table_204_337 (id NUMBER, "festival" CLOB, "year" NUMBER, "award" CLOB, "nominee" CLOB, "result" CLOB)

how many more winners were there than nominees ?
SELECT (SELECT COUNT(*) FROM table_204_337 WHERE "result" = 'won') - (SELECT COUNT(*) FROM table_204_337 WHERE "result" = 'nominated')
WITH "_u_0" AS (SELECT COUNT(*), 'won' AS "_u_1" FROM "table_204_337" GROUP BY 'won'), "_u_2" AS (SELECT COUNT(*), 'nominated' AS "_u_3" FROM "table_204_337" GROUP BY 'nominated') SELECT 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"