i put this filter on sample in order to create a column who count the number of times when open ep, ep 3bet
tourney_hand_player_statistics.flg_p_first_raise
and tourney_hand_player_statistics.flg_p_3bet_def_opp and not tourney_hand_player_statistics.flg_p_squeeze
AND ((tourney_hand_summary.cnt_players BETWEEN 4 and 6 and substring(tourney_hand_summary.str_aggressors_p from 3 for 2)::int BETWEEN 3 and 5) OR (tourney_hand_summary.cnt_players BETWEEN 7 and
8 and substring(tourney_hand_summary.str_aggressors_p from 3 for 2)::int BETWEEN 4 and 7) OR (tourney_hand_summary.cnt_players BETWEEN 9 and 10 and
substring(tourney_hand_summary.str_aggressors_p from 3 for 2)::int BETWEEN 5 and 7) )
but i have hands with ep open call and squizz from the btn and even hands with ep open and 3bet btn in 9 max , and i cant figure why with that filter
help pls
regards