The scenario is as follows:
BTN folds preflop.
SB call preflop.
BB check.
SB makes a C-Bet on the flop.
BB folds.
- Code: Select all
sum(if[
tourney_hand_player_statistics.position = 8
AND tourney_hand_summary.cnt_players = 3
AND tourney_hand_summary.str_actors_p LIKE '9%'
AND tourney_hand_player_statistics.cnt_p_face_limpers = 1
AND tourney_hand_player_statistics.amt_p_raise_made = 0
AND tourney_hand_player_statistics.amt_f_bet_facing > 0
AND lookup_actions_f.action = 'F'
, 1, 0])
- Code: Select all
sum(if[
tourney_hand_player_statistics.position = 8
AND tourney_hand_summary.cnt_players = 3
AND tourney_hand_summary.str_actors_p LIKE '9%'
AND tourney_hand_player_statistics.cnt_p_face_limpers = 1
AND tourney_hand_player_statistics.amt_p_raise_made = 0
AND tourney_hand_player_statistics.amt_f_bet_facing > 0
, 1, 0])
