CREATE TABLE table_204_413 (id NUMBER, "medal" CLOB, "name" CLOB, "sport" CLOB, "event" CLOB, "date" CLOB)

how many more silver medals were handed out than gold ?
SELECT (SELECT COUNT(*) FROM table_204_413 WHERE "medal" = 'silver') - (SELECT COUNT(*) FROM table_204_413 WHERE "medal" = 'gold')
WITH "_u_0" AS (SELECT COUNT(*), 'silver' AS "_u_1" FROM "table_204_413" GROUP BY 'silver'), "_u_2" AS (SELECT COUNT(*), 'gold' AS "_u_3" FROM "table_204_413" GROUP BY 'gold') SELECT COALESCE("_u_0"."", *) - COALESCE("_u_2"."", *) LEFT JOIN "_u_0" "_u_0" ON "_u_0"."_u_1" = "medal" LEFT JOIN "_u_2" "_u_2" ON "_u_2"."_u_3" = "medal"