summaryrefslogtreecommitdiff
path: root/crunch_team.sql
diff options
context:
space:
mode:
Diffstat (limited to 'crunch_team.sql')
-rw-r--r--crunch_team.sql11
1 files changed, 9 insertions, 2 deletions
diff --git a/crunch_team.sql b/crunch_team.sql
index 4133cf4..fb94418 100644
--- a/crunch_team.sql
+++ b/crunch_team.sql
@@ -3,8 +3,15 @@ JOIN (
SELECT
tm.id AS tm_id,
SUM(
- (1 + (tm_cnt-2) * 0.3) *
- (p.winner * 0.3 + 0.7) *
+ (CASE
+ WHEN tm_cnt=1 THEN 0.33
+ WHEN tm_cnt=2 THEN 0.66
+ WHEN tm_cnt=3 THEN 1.33
+ ) *
+ (CASE
+ WHEN p.winner THEN 1
+ WHEN NOT p.winner THEN 0.7
+ ) *
(CASE
WHEN tm.status='initiate' THEN 10
WHEN tm.status='member' THEN 75