CREATE TABLE table_204_784 (id NUMBER, "player" CLOB, "league" NUMBER, "cup" NUMBER, "europa league" NUMBER, "total" NUMBER)

how many players had a total of 4 ?
SELECT COUNT("player") FROM table_204_784 WHERE "total" = 4
SELECT COUNT("player") FROM "table_204_784" WHERE "total" = 4