I suspect that your problem lies in this part: cash_hand_player_statistics.amt_p_raise_made BETWEEN 2.21 AND 2.7 * cash_limit.amt_bb That is probably not giving you what you expect. I think it will be doing this: cash_hand_player_statistics.amt_p_raise_made BETWEEN 2.21 AND (2.7 * cash_limit.amt_bb)...