inflection_towers (view)

21 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Losses, Winrate

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
SpikeFactory 1608 918 690 57.09% 17.95% 54.67%
DartMonkey 1152 657 495 57.03% 12.86% 54.17%
BananaFarm 2079 1119 960 53.82% 23.21% 51.68%
MortarMonkey 140 81 59 57.86% 1.56% 49.68%
MonkeySub 599 309 290 51.59% 6.69% 47.58%
BoomerangMonkey 392 202 190 51.53% 4.38% 46.58%
DartlingGunner 475 219 256 46.11% 5.30% 41.62%
SuperMonkey 109 50 59 45.87% 1.22% 36.52%
Alchemist 238 100 138 42.02% 2.66% 35.75%
SniperMonkey 330 132 198 40.00% 3.68% 34.71%
WizardMonkey 387 152 235 39.28% 4.32% 34.41%
NinjaMonkey 262 99 163 37.79% 2.92% 31.92%
GlueGunner 181 70 111 38.67% 2.02% 31.58%
Druid 126 50 76 39.68% 1.41% 31.14%
TackShooter 250 92 158 36.80% 2.79% 30.82%
MonkeyVillage 142 54 88 38.03% 1.59% 30.04%
EngineerMonkey 62 26 36 41.94% 0.69% 29.65%
BombShooter 63 25 38 39.68% 0.70% 27.60%
HeliPilot 55 22 33 40.00% 0.61% 27.05%
MonkeyBuccaneer 131 46 85 35.11% 1.46% 26.94%
IceMonkey 143 48 95 33.57% 1.60% 25.83%

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;