inflection_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
DartlingGunner 439 253 186 57.63% 5.82% 53.01%
SpikeFactory 1263 685 578 54.24% 16.73% 51.49%
BananaFarm 1772 940 832 53.05% 23.48% 50.72%
MonkeySub 616 333 283 54.06% 8.16% 50.12%
MortarMonkey 92 54 38 58.70% 1.22% 48.63%
DartMonkey 733 368 365 50.20% 9.71% 46.58%
NinjaMonkey 235 124 111 52.77% 3.11% 46.38%
BoomerangMonkey 278 131 147 47.12% 3.68% 41.25%
EngineerMonkey 68 35 33 51.47% 0.90% 39.59%
WizardMonkey 361 159 202 44.04% 4.78% 38.92%
SniperMonkey 327 142 185 43.43% 4.33% 38.05%
HeliPilot 92 44 48 47.83% 1.22% 37.62%
IceMonkey 179 77 102 43.02% 2.37% 35.76%
Alchemist 176 74 102 42.05% 2.33% 34.75%
SuperMonkey 100 44 56 44.00% 1.32% 34.27%
TackShooter 253 101 152 39.92% 3.35% 33.89%
Druid 90 39 51 43.33% 1.19% 33.10%
MonkeyVillage 138 52 86 37.68% 1.83% 29.60%
GlueGunner 152 56 96 36.84% 2.01% 29.17%
MonkeyAce 32 14 18 43.75% 0.42% 26.56%
MonkeyBuccaneer 94 33 61 35.11% 1.25% 25.46%
BombShooter 58 16 42 27.59% 0.77% 16.08%

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;