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

what are the number of times hard appears as the surface ?
SELECT COUNT(*) FROM table_204_47 WHERE "surface" = 'hard'
SELECT COUNT(*) FROM "table_204_47" WHERE "surface" = 'hard'