inflection_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
BananaFarm 1726 945 781 54.75% 18.07% 52.40%
SpikeFactory 1669 901 768 53.98% 17.47% 51.59%
DartMonkey 1248 669 579 53.61% 13.07% 50.84%
DartlingGunner 625 342 283 54.72% 6.54% 50.82%
SuperMonkey 205 116 89 56.59% 2.15% 49.80%
MortarMonkey 234 131 103 55.98% 2.45% 49.62%
IceMonkey 145 83 62 57.24% 1.52% 49.19%
BoomerangMonkey 471 240 231 50.96% 4.93% 46.44%
Alchemist 407 194 213 47.67% 4.26% 42.81%
MonkeySub 269 125 144 46.47% 2.82% 40.51%
MonkeyBuccaneer 276 123 153 44.57% 2.89% 38.70%
NinjaMonkey 213 96 117 45.07% 2.23% 38.39%
MonkeyVillage 206 90 116 43.69% 2.16% 36.92%
SniperMonkey 373 155 218 41.55% 3.90% 36.55%
WizardMonkey 405 162 243 40.00% 4.24% 35.23%
EngineerMonkey 118 52 66 44.07% 1.24% 35.11%
TackShooter 276 109 167 39.49% 2.89% 33.73%
Druid 108 44 64 40.74% 1.13% 31.47%
HeliPilot 117 47 70 40.17% 1.22% 31.29%
GlueGunner 302 105 197 34.77% 3.16% 29.40%
MonkeyAce 58 24 34 41.38% 0.61% 28.70%
BombShooter 101 23 78 22.77% 1.06% 14.59%

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;