CREATE TABLE table_204_784 (id DECIMAL, "player" TEXT, "league" DECIMAL, "cup" DECIMAL, "europa league" DECIMAL, "total" DECIMAL)

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