CREATE TABLE table_204_413 (id DECIMAL, "medal" TEXT, "name" TEXT, "sport" TEXT, "event" TEXT, "date" TEXT)

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" AS "_u_0" ON "_u_0"."_u_1" = "medal" LEFT JOIN "_u_2" AS "_u_2" ON "_u_2"."_u_3" = "medal"