Fold BB to steal query

[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

[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)