diff options
| -rw-r--r-- | crunch_team.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/crunch_team.sql b/crunch_team.sql index fb94418..a11cc33 100644 --- a/crunch_team.sql +++ b/crunch_team.sql @@ -7,11 +7,11 @@ JOIN ( WHEN tm_cnt=1 THEN 0.33 WHEN tm_cnt=2 THEN 0.66 WHEN tm_cnt=3 THEN 1.33 - ) * + END) * (CASE - WHEN p.winner THEN 1 - WHEN NOT p.winner THEN 0.7 - ) * + WHEN p.winner=TRUE THEN 1 + WHEN p.winner=FALSE THEN 0.7 + END) * (CASE WHEN tm.status='initiate' THEN 10 WHEN tm.status='member' THEN 75 |
