salmon_pool_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Losses

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
DartMonkey 338 206 132 60.95% 3.61% 55.75%
Alchemist 642 359 283 55.92% 6.86% 52.08%
SpikeFactory 1114 611 503 54.85% 11.91% 51.93%
MonkeyBuccaneer 870 475 395 54.60% 9.30% 51.29%
DartlingGunner 371 206 165 55.53% 3.97% 50.47%
WizardMonkey 600 305 295 50.83% 6.41% 46.83%
BananaFarm 1473 714 759 48.47% 15.75% 45.92%
EngineerMonkey 177 93 84 52.54% 1.89% 45.19%
MonkeyVillage 262 134 128 51.15% 2.80% 45.09%
SniperMonkey 437 208 229 47.60% 4.67% 42.91%
IceMonkey 303 144 159 47.52% 3.24% 41.90%
MonkeySub 777 350 427 45.05% 8.31% 41.55%
MonkeyAce 100 51 49 51.00% 1.07% 41.20%
BoomerangMonkey 280 131 149 46.79% 2.99% 40.94%
SuperMonkey 225 106 119 47.11% 2.41% 40.59%
NinjaMonkey 242 112 130 46.28% 2.59% 40.00%
BombShooter 340 151 189 44.41% 3.63% 39.13%
TackShooter 290 123 167 42.41% 3.10% 36.73%
Druid 147 63 84 42.86% 1.57% 34.86%
HeliPilot 170 70 100 41.18% 1.82% 33.78%
GlueGunner 150 49 101 32.67% 1.60% 25.16%
MortarMonkey 46 16 30 34.78% 0.49% 21.02%

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;