CREATE TABLE table_204_47 (id DECIMAL, "outcome" TEXT, "no." DECIMAL, "date" TEXT, "tournament" TEXT, "surface" TEXT, "partner" TEXT, "opponents" TEXT, "score" TEXT)

was there more clay surfaces used than hard surfaces ?
SELECT (SELECT COUNT(*) FROM table_204_47 WHERE "surface" = 'clay') > (SELECT COUNT(*) FROM table_204_47 WHERE "surface" = 'hard')
WITH "_u_0" AS (SELECT COUNT(*), 'clay' AS "_u_1" FROM "table_204_47" GROUP BY 'clay'), "_u_2" AS (SELECT COUNT(*), 'hard' AS "_u_3" FROM "table_204_47" GROUP BY 'hard') SELECT COALESCE("_u_0"."", *) > COALESCE("_u_2"."", *) LEFT JOIN "_u_0" AS "_u_0" ON "_u_0"."_u_1" = "surface" LEFT JOIN "_u_2" AS "_u_2" ON "_u_2"."_u_3" = "surface"