CREATE TABLE table_204_154 (id NUMBER, "player" CLOB, "matches" NUMBER, "innings" NUMBER, "runs" NUMBER, "average" NUMBER, "100s" NUMBER, "50s" NUMBER)

how many players played more than 10 matches ?
SELECT COUNT("player") FROM table_204_154 WHERE "matches" > 10
SELECT COUNT("player") FROM "table_204_154" WHERE "matches" > 10