inflection_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
BananaFarm 1450 814 636 56.14% 17.31% 53.58%
DartMonkey 1174 654 520 55.71% 14.02% 52.87%
SpikeFactory 1360 725 635 53.31% 16.24% 50.66%
EngineerMonkey 101 59 42 58.42% 1.21% 48.80%
BoomerangMonkey 295 160 135 54.24% 3.52% 48.55%
DartlingGunner 529 275 254 51.98% 6.32% 47.73%
IceMonkey 137 75 62 54.74% 1.64% 46.41%
MortarMonkey 180 96 84 53.33% 2.15% 46.05%
SniperMonkey 424 197 227 46.46% 5.06% 41.71%
Alchemist 375 172 203 45.87% 4.48% 40.82%
MonkeySub 233 110 123 47.21% 2.78% 40.80%
SuperMonkey 235 108 127 45.96% 2.81% 39.59%
NinjaMonkey 232 102 130 43.97% 2.77% 37.58%
MonkeyBuccaneer 213 92 121 43.19% 2.54% 36.54%
WizardMonkey 328 131 197 39.94% 3.92% 34.64%
MonkeyAce 53 25 28 47.17% 0.63% 33.73%
GlueGunner 332 129 203 38.86% 3.96% 33.61%
BombShooter 93 39 54 41.94% 1.11% 31.91%
Druid 116 47 69 40.52% 1.38% 31.58%
HeliPilot 49 22 27 44.90% 0.59% 30.97%
TackShooter 230 78 152 33.91% 2.75% 27.79%
MonkeyVillage 237 78 159 32.91% 2.83% 26.93%

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;