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 232 147 85 63.36% 2.04% 57.16%
SpikeFactory 1407 729 678 51.81% 12.36% 49.20%
MonkeySub 1184 616 568 52.03% 10.40% 49.18%
BananaFarm 1696 872 824 51.42% 14.89% 49.04%
Alchemist 1016 529 487 52.07% 8.92% 49.00%
MonkeyBuccaneer 1232 637 595 51.70% 10.82% 48.91%
BombShooter 709 367 342 51.76% 6.23% 48.08%
EngineerMonkey 222 121 101 54.50% 1.95% 47.95%
DartlingGunner 312 159 153 50.96% 2.74% 45.41%
DartMonkey 337 169 168 50.15% 2.96% 44.81%
WizardMonkey 533 253 280 47.47% 4.68% 43.23%
SuperMonkey 249 122 127 49.00% 2.19% 42.79%
SniperMonkey 416 191 225 45.91% 3.65% 41.12%
IceMonkey 152 71 81 46.71% 1.33% 38.78%
Druid 197 89 108 45.18% 1.73% 38.23%
NinjaMonkey 254 112 142 44.09% 2.23% 37.99%
MonkeyVillage 231 101 130 43.72% 2.03% 37.33%
TackShooter 259 109 150 42.08% 2.27% 36.07%
GlueGunner 296 120 176 40.54% 2.60% 34.95%
BoomerangMonkey 219 90 129 41.10% 1.92% 34.58%
MortarMonkey 65 28 37 43.08% 0.57% 31.04%
HeliPilot 170 62 108 36.47% 1.49% 29.23%

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;