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 217 144 73 66.36% 2.04% 60.07%
MortarMonkey 98 65 33 66.33% 0.92% 56.97%
EngineerMonkey 217 127 90 58.53% 2.04% 51.97%
BananaFarm 1289 704 585 54.62% 12.09% 51.90%
MonkeySub 603 332 271 55.06% 5.66% 51.09%
BombShooter 306 173 133 56.54% 2.87% 50.98%
DartMonkey 632 334 298 52.85% 5.93% 48.96%
SpikeFactory 1530 784 746 51.24% 14.35% 48.74%
Alchemist 904 464 440 51.33% 8.48% 48.07%
MonkeyBuccaneer 1296 651 645 50.23% 12.16% 47.51%
DartlingGunner 321 167 154 52.02% 3.01% 46.56%
Druid 316 161 155 50.95% 2.96% 45.44%
WizardMonkey 500 222 278 44.40% 4.69% 40.04%
BoomerangMonkey 247 112 135 45.34% 2.32% 39.14%
IceMonkey 204 92 112 45.10% 1.91% 38.27%
MonkeyVillage 272 120 152 44.12% 2.55% 38.22%
SniperMonkey 526 218 308 41.44% 4.93% 37.23%
NinjaMonkey 205 88 117 42.93% 1.92% 36.15%
GlueGunner 363 149 214 41.05% 3.40% 35.99%
SuperMonkey 301 109 192 36.21% 2.82% 30.78%
TackShooter 204 76 128 37.25% 1.91% 30.62%
HeliPilot 111 39 72 35.14% 1.04% 26.25%

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;