Facing a delayed CB on the turn

[Dan_Jazz_Man]

Would this be a correct query to count the number of times a player faces a delay CB on the turn?

Code: Select all

sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 2 and char_length(cash_hand_summary.str_aggressors_t) >= 1 and lookup_actions_f.action = 'X' and cash_hand_player_statistics.amt_t_bet_facing > 0 and substring(cash_hand_summary.str_aggressors_t from 1 for 1)::int = substring(cash_hand_summary.str_aggressors_p from '.$')::int, 1, 0])

And for 3Bet+ pot I'd need to use

Code: Select all

char_length(cash_hand_summary.str_aggressors_p) >= 3

Thanks!

[Flag_Hippo]

Would this be a correct query to count the number of times a player faces a delay CB on the turn?

Code: Select all

sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 2 and char_length(cash_hand_summary.str_aggressors_t) >= 1 and lookup_actions_f.action = 'X' and cash_hand_player_statistics.amt_t_bet_facing > 0 and substring(cash_hand_summary.str_aggressors_t from 1 for 1)::int = substring(cash_hand_summary.str_aggressors_p from '.$')::int, 1, 0])

Yes.

And for 3Bet+ pot I'd need to use

Code: Select all

char_length(cash_hand_summary.str_aggressors_p) >= 3

Yes although those hands are already included in your original expression. You might want that but if you want single raised pots and 3bet+ pots separated then the first expression will need changing to:

Code: Select all

char_length(cash_hand_summary.str_aggressors_p) = 2

[Dan_Jazz_Man]

Thank you, Flag_Hippo