Page 1 of 1

Fold BB to steal query

PostPosted: Sat Jun 07, 2008 10:09 am
by DerekG
Because I'm a SQL noob, I can't figure out how to query this manually. Can someone help?

Folded BB to Steal
Full Name: Folded Big Blind to Steal
Description: The percentage of time a player folded the big blind to a steal attempt
Formula: ( Total Times Folded BB To Steal / Total BB Steal Defense Opportunities ) * 100

Re: Fold BB to steal query

PostPosted: Sat Jun 07, 2008 11:11 am
by DerekG
nvm - think I may have figured it out?

SUM(case when (hhps.flg_bb_steal_fold) then 1 else 0 end) || '/' || SUM(case when (hhps.flg_blind_def_opp) AND (hhps.flg_blind_b) THEN 1 ELSE 0 END)