SQL Command

[sun_bubba]

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

[sun_bubba]

If I could get EV in my HUD I would not need to write SQL.
Anyway to get EV for players in the HUD?