sun_bubba
10-08-2009, 09:23 PM
Hi:
I need help with a sql command. See below. This code does what I want except instead of totalbbswon, I would like this value adjusted for All-IN EV. Is there anyway to do this.
Thanks,
William
select P.PlayerName, sum(GMCPR.totalplayedhands) as TotalHands,
sum(vpiphands) as VPIPHands, sum(pfrhands) as PFRHands,
sum(totalbbswon) as won
from GetMatchingCompiledPlayerResults_month(5,9,200810, 200910,ARRAY[5,4,3,2,1]) GMCPR,
Players P, CompiledPlayerResults_month CPR
where GMCPR.player_ID in (select player_ID from GetMatchingCompiledPlayerResults_month(5,9,200810, 200910,ARRAY[5,4,3,2,1])
group by player_ID having sum(totalplayedhands) >= 200 )
and P.Player_ID = GMCPR.Player_id
and GMCPR.CompiledPlayerResults_ID = CPR.CompiledPlayerResults_ID
group by P.PlayerName,P.Site_ID,GMCPR.player_id order by TotalHands desc
I need help with a sql command. See below. This code does what I want except instead of totalbbswon, I would like this value adjusted for All-IN EV. Is there anyway to do this.
Thanks,
William
select P.PlayerName, sum(GMCPR.totalplayedhands) as TotalHands,
sum(vpiphands) as VPIPHands, sum(pfrhands) as PFRHands,
sum(totalbbswon) as won
from GetMatchingCompiledPlayerResults_month(5,9,200810, 200910,ARRAY[5,4,3,2,1]) GMCPR,
Players P, CompiledPlayerResults_month CPR
where GMCPR.player_ID in (select player_ID from GetMatchingCompiledPlayerResults_month(5,9,200810, 200910,ARRAY[5,4,3,2,1])
group by player_ID having sum(totalplayedhands) >= 200 )
and P.Player_ID = GMCPR.Player_id
and GMCPR.CompiledPlayerResults_ID = CPR.CompiledPlayerResults_ID
group by P.PlayerName,P.Site_ID,GMCPR.player_id order by TotalHands desc