|
Howard 发表于 2013-3-27 09:26
topaz的这个例子让我学到不少东西。谢谢
所写的PQL句子看着很臃肿,主要原因是对“turncard 出红桃” 的表 ...
“turn A" 和 “turn出红桃”的简洁表示办法找到了:boardInRange('***A') boardInRange('hhhh')
用此语句重新书写topaz朋友的第二问和第三问。
option2:
select avg(
case
when boardInRange('***A') then RiverEquity(hero)*175 - 75
when boardInRange('hhhh') then
case
when InRange(opp,'h') then RiverEquity(hero)*175 - 75
else 25+25
end
else -25
end
) as Option2_EV
from game = 'holdem', hero = 'Ah9c', opp='20%', board = 'Jh6h2h'
where (flopHandCategory(opp)>=floptoppair)
计算结果是-4.0BB 与前述一致
Option3:
select avg(case
when boardInRange('hhhh') then
case
when InRange(opp,'h') then RiverEquity(hero)*175 - 75
else 25+25
end
else -25
end
) as Option3_EV
from game = 'holdem', hero = 'Ah9c', opp='20%', board = 'Jh6h2h'
where (flopHandCategory(opp)>=floptoppair)
计算结果-8.3BB,与前述基本一致 |
|