I want to create a statistical indicator that counts the number of hands of a player, the sum of the stacks of players in which is equal to 67500.
I wrote a column:
SELECT SUM (tournament hand_player_statistics.amt_before)
FROM tournament hand_player_statistics
WHERE tournament hand_player_statistics.id_hand = tourney_hand_summary.id_hand
As a result, the total number of the player's hands is displayed in the hud.
Please help to correct the statistical indicator so that the correct result is displayed in the hud.