salmon_pool_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MonkeyAce 1318 757 561 57.44% 1.57% 54.77%
Alchemist 6708 3618 3090 53.94% 8.01% 52.74%
BombShooter 3146 1706 1440 54.23% 3.76% 52.49%
SpikeFactory 10428 5511 4917 52.85% 12.45% 51.89%
BananaFarm 11934 6279 5655 52.61% 14.25% 51.72%
MonkeyBuccaneer 9014 4713 4301 52.29% 10.76% 51.25%
MonkeySub 7240 3789 3451 52.33% 8.64% 51.18%
DartMonkey 3615 1889 1726 52.25% 4.32% 50.63%
MortarMonkey 731 388 343 53.08% 0.87% 49.46%
EngineerMonkey 1414 730 684 51.63% 1.69% 49.02%
DartlingGunner 2462 1236 1226 50.20% 2.94% 48.23%
IceMonkey 2374 1137 1237 47.89% 2.83% 45.88%
Druid 1666 786 880 47.18% 1.99% 44.78%
WizardMonkey 4332 1992 2340 45.98% 5.17% 44.50%
SuperMonkey 2084 949 1135 45.54% 2.49% 43.40%
BoomerangMonkey 1967 872 1095 44.33% 2.35% 42.14%
MonkeyVillage 1956 853 1103 43.61% 2.34% 41.41%
SniperMonkey 3648 1567 2081 42.96% 4.36% 41.35%
NinjaMonkey 1987 826 1161 41.57% 2.37% 39.40%
TackShooter 2065 845 1220 40.92% 2.47% 38.80%
HeliPilot 1232 495 737 40.18% 1.47% 37.44%
GlueGunner 2439 942 1497 38.62% 2.91% 36.69%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW salmon_pool_towers AS 
WITH salmon_pool AS
    (SELECT *
    FROM matches
    WHERE map = 'salmon_pool')
SELECT Tower,
       Games,
       Wins,
       Losses,
       printf('%.2f%%', WR * 100)                                          AS Winrate,
       printf('%.2f%%', PR * 100)                                          AS Pickrate,
       printf('%.2f%%', (WR - 1.96 * SQRT((WR * (1 - WR)) / Games)) * 100) AS Winrate_LowerBound_95CI
FROM (SELECT Tower,
             Games,
             Wins,
             Losses,
             CAST(Wins AS REAL) / Games AS WR,
             CAST(Games AS REAL) / (
                 (SELECT COUNT(*)
                  FROM salmon_pool) * 6)    AS PR
      FROM (SELECT Tower,
                   SUM(Win) + SUM(NOT Win) AS Games,
                   SUM(Win)                AS Wins,
                   SUM(NOT Win)            AS Losses
            FROM (SELECT lt1           AS Tower,
                         playerLeftWin AS Win
                  FROM salmon_pool
                  UNION ALL
                  SELECT lt2           AS Tower,
                         playerLeftWin AS Win
                  FROM salmon_pool
                  UNION ALL
                  SELECT lt3           AS Tower,
                         playerLeftWin AS Win
                  FROM salmon_pool
                  UNION ALL
                  SELECT rt1               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM salmon_pool
                  UNION ALL
                  SELECT rt2               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM salmon_pool
                  UNION ALL
                  SELECT rt3               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM salmon_pool)
            GROUP BY Tower))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;