CREATE TABLE table_204_678 (id DECIMAL, "record" TEXT, "athlete" TEXT, "nation" TEXT, "venue" TEXT, "date" TEXT, "#" DECIMAL)

how many nations have set the record more than the united states ?
SELECT COUNT(*) FROM (SELECT "nation" FROM table_204_678 GROUP BY "nation" HAVING COUNT(*) > (SELECT COUNT(*) FROM table_204_678 WHERE "nation" = 'united states'))
WITH "_u_0" AS (SELECT COUNT(*), 'united states' AS "_u_1" FROM "table_204_678" GROUP BY 'united states'), "cte" AS (SELECT 1 AS "_" FROM "table_204_678" LEFT JOIN "_u_0" AS "_u_0" ON "_u_0"."_u_1" = "nation" GROUP BY "nation" HAVING COALESCE("_u_0"."", *) < COUNT(*)) SELECT COUNT(*) FROM "cte" AS "cte"