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

has she won more doubles tournaments on clay or on hard ?
SELECT "surface" FROM table_204_47 WHERE "surface" IN ('clay', 'hard') GROUP BY "surface" ORDER BY COUNT(*) DESC LIMIT 1
SELECT "surface" FROM "table_204_47" WHERE "surface" IN ('clay', 'hard') GROUP BY "surface" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY