was there more clay surfaces used than hard surfaces ?
CREATE TABLE table_204_47 (
    id number,
    "outcome" text,
    "no." number,
    "date" text,
    "tournament" text,
    "surface" text,
    "partner" text,
    "opponents" text,
    "score" text
)
SELECT (SELECT COUNT(*) FROM table_204_47 WHERE "surface" = 'clay') > (SELECT COUNT(*) FROM table_204_47 WHERE "surface" = 'hard')
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: was there more clay surfaces used than hard surfaces ? ### Input: CREATE TABLE table_204_47 (
    id number,
    "outcome" text,
    "no." number,
    "date" text,
    "tournament" text,
    "surface" text,
    "partner" text,
    "opponents" text,
    "score" text
) ### Response: SELECT (SELECT COUNT(*) FROM table_204_47 WHERE "surface" = 'clay') > (SELECT COUNT(*) FROM table_204_47 WHERE "surface" = 'hard')