inflection_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
DartMonkey 1136 666 470 58.63% 13.38% 55.76%
BananaFarm 1799 986 813 54.81% 21.19% 52.51%
SpikeFactory 1483 813 670 54.82% 17.47% 52.29%
MortarMonkey 114 65 49 57.02% 1.34% 47.93%
DartlingGunner 564 284 280 50.35% 6.64% 46.23%
BoomerangMonkey 402 194 208 48.26% 4.73% 43.37%
IceMonkey 119 58 61 48.74% 1.40% 39.76%
MonkeySub 335 151 184 45.07% 3.95% 39.75%
Alchemist 334 143 191 42.81% 3.93% 37.51%
HeliPilot 83 40 43 48.19% 0.98% 37.44%
GlueGunner 242 103 139 42.56% 2.85% 36.33%
NinjaMonkey 250 103 147 41.20% 2.94% 35.10%
TackShooter 217 89 128 41.01% 2.56% 34.47%
SniperMonkey 254 101 153 39.76% 2.99% 33.74%
Druid 120 51 69 42.50% 1.41% 33.66%
MonkeyBuccaneer 158 65 93 41.14% 1.86% 33.47%
SuperMonkey 141 58 83 41.13% 1.66% 33.01%
WizardMonkey 374 136 238 36.36% 4.41% 31.49%
EngineerMonkey 99 39 60 39.39% 1.17% 29.77%
MonkeyVillage 159 58 101 36.48% 1.87% 29.00%
BombShooter 67 27 40 40.30% 0.79% 28.55%
MonkeyAce 40 15 25 37.50% 0.47% 22.50%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW inflection_towers AS 
WITH inflection AS
    (SELECT *
    FROM matches
    WHERE map = 'inflection')
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 inflection) * 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 inflection
                  UNION ALL
                  SELECT lt2           AS Tower,
                         playerLeftWin AS Win
                  FROM inflection
                  UNION ALL
                  SELECT lt3           AS Tower,
                         playerLeftWin AS Win
                  FROM inflection
                  UNION ALL
                  SELECT rt1               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM inflection
                  UNION ALL
                  SELECT rt2               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM inflection
                  UNION ALL
                  SELECT rt3               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM inflection)
            GROUP BY Tower))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;