Hi,
I tried searching the forum but I couldn't find anything about this:
I want to write a cutom stat where villain limp-fold OOP.
I deifined one of the colum, the number of opportunities, like this:
sum(if[cash_hand_summary.cnt_players >= 3
and cash_hand_player_statistics.flg_p_limp
and cash_hand_player_statistics.flg_p_face_raise
and cash_hand_player_statistics.val_p_raise_aggressor_pos < cash_hand_player_statistics.position, 1, 0])
but now I need to exclude hands where a third player cold called (because of course then the limper will be less prone to fold), but I can't find a way to achieve that.
I tried to add something like this:
and not exists
(select 1
from cash_hand_player_statistics villain
where villain.id_hand = cash_hand_player_statistics.id_hand
and villain.flg_p_ccall)
but it doesn't work, clearly I haven't understood how this works.
Any hint? Thanks