problem with expression in custom stat

[chadi99]

I am trying to add this stat: "Number of times player raised the river then went to showdown and won the hand", but I get the message that the expression is invalid. I have been trying to use the following expression. Please let me know how I can correct it.

sum(if[cash_hand_player_statistics.cnt_r_bet > 0 AND cash_hand_player_statistics.flg_showdown AND cash_hand_player_statistics.flg_won_hand, 1, 0])

[Flag_Hippo]

That expression isn't valid SQL because cash_hand_player_statistics.cnt_r_bet doesn't exist in the database so replace that with cash_hand_player_statistics.cnt_r_raise.