CREATE TABLE table_204_678 (id NUMBER, "record" CLOB, "athlete" CLOB, "nation" CLOB, "venue" CLOB, "date" CLOB, "#" NUMBER)

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" "_u_0" ON "_u_0"."_u_1" = "nation" GROUP BY "nation" HAVING COALESCE("_u_0"."", *) < COUNT(*)) SELECT COUNT(*) FROM "cte" "cte"