summaryrefslogtreecommitdiff
path: root/crunch_team.sql
diff options
context:
space:
mode:
Diffstat (limited to 'crunch_team.sql')
-rw-r--r--crunch_team.sql8
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