inflection_towers (view)

20 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Winrate, Pickrate

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
DartMonkey 278 155 123 55.76% 12.83% 49.92%
SpikeFactory 371 202 169 54.45% 17.13% 49.38%
BananaFarm 527 274 253 51.99% 24.33% 47.73%
DartlingGunner 161 86 75 53.42% 7.43% 45.71%
SuperMonkey 30 18 12 60.00% 1.39% 42.47%
NinjaMonkey 79 39 40 49.37% 3.65% 38.34%
BoomerangMonkey 110 51 59 46.36% 5.08% 37.04%
MonkeySub 86 40 46 46.51% 3.97% 35.97%
Alchemist 75 35 40 46.67% 3.46% 35.38%
EngineerMonkey 29 15 14 51.72% 1.34% 33.54%
Druid 29 14 15 48.28% 1.34% 30.09%
MonkeyBuccaneer 38 17 21 44.74% 1.75% 28.93%
GlueGunner 30 14 16 46.67% 1.39% 28.81%
MortarMonkey 36 16 20 44.44% 1.66% 28.21%
HeliPilot 26 12 14 46.15% 1.20% 26.99%
MonkeyVillage 35 15 20 42.86% 1.62% 26.46%
WizardMonkey 99 34 65 34.34% 4.57% 24.99%
TackShooter 48 18 30 37.50% 2.22% 23.80%
SniperMonkey 36 14 22 38.89% 1.66% 22.96%
IceMonkey 26 10 16 38.46% 1.20% 19.76%

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;