salmon_pool_towers (view)

19 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Pickrate

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
SpikeFactory 278 148 130 53.24% 12.19% 47.37%
WizardMonkey 121 68 53 56.20% 5.31% 47.36%
Alchemist 160 87 73 54.38% 7.02% 46.66%
MonkeyBuccaneer 228 120 108 52.63% 10.00% 46.15%
MonkeySub 233 120 113 51.50% 10.22% 45.08%
BananaFarm 427 212 215 49.65% 18.73% 44.91%
IceMonkey 98 52 46 53.06% 4.30% 43.18%
BombShooter 88 43 45 48.86% 3.86% 38.42%
DartMonkey 93 45 48 48.39% 4.08% 38.23%
Druid 37 20 17 54.05% 1.62% 38.00%
NinjaMonkey 71 34 37 47.89% 3.11% 36.27%
SniperMonkey 78 35 43 44.87% 3.42% 33.83%
DartlingGunner 71 30 41 42.25% 3.11% 30.76%
TackShooter 44 20 24 45.45% 1.93% 30.74%
EngineerMonkey 34 16 18 47.06% 1.49% 30.28%
BoomerangMonkey 65 27 38 41.54% 2.85% 29.56%
MonkeyVillage 37 15 22 40.54% 1.62% 24.72%
SuperMonkey 26 10 16 38.46% 1.14% 19.76%
GlueGunner 38 13 25 34.21% 1.67% 19.13%

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;