CREATE TABLE table_204_562 (id NUMBER, "no." NUMBER, "date" CLOB, "location" CLOB, "surface" CLOB, "opponent in final" CLOB, "score" CLOB)

how many matches were played on a hard surface ?
SELECT COUNT(*) FROM table_204_562 WHERE "surface" = 'hard'
SELECT COUNT(*) FROM "table_204_562" WHERE "surface" = 'hard'