glade_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MortarMonkey 223 138 85 61.88% 2.19% 55.51%
DartMonkey 1159 676 483 58.33% 11.36% 55.49%
SpikeFactory 1468 806 662 54.90% 14.39% 52.36%
BananaFarm 2379 1280 1099 53.80% 23.32% 51.80%
MonkeySub 502 248 254 49.40% 4.92% 45.03%
WizardMonkey 692 334 358 48.27% 6.78% 44.54%
BoomerangMonkey 702 334 368 47.58% 6.88% 43.88%
TackShooter 450 202 248 44.89% 4.41% 40.29%
BombShooter 114 55 59 48.25% 1.12% 39.07%
IceMonkey 172 79 93 45.93% 1.69% 38.48%
DartlingGunner 290 128 162 44.14% 2.84% 38.42%
Druid 166 76 90 45.78% 1.63% 38.20%
HeliPilot 78 36 42 46.15% 0.76% 35.09%
MonkeyVillage 194 81 113 41.75% 1.90% 34.81%
NinjaMonkey 361 143 218 39.61% 3.54% 34.57%
SniperMonkey 424 166 258 39.15% 4.16% 34.51%
GlueGunner 238 95 143 39.92% 2.33% 33.69%
SuperMonkey 167 67 100 40.12% 1.64% 32.69%
Alchemist 163 63 100 38.65% 1.60% 31.17%
EngineerMonkey 97 38 59 39.18% 0.95% 29.46%
MonkeyBuccaneer 115 40 75 34.78% 1.13% 26.08%
MonkeyAce 46 15 31 32.61% 0.45% 19.06%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW glade_towers AS 
WITH glade AS
    (SELECT *
    FROM matches
    WHERE map = 'glade')
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 glade) * 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 glade
                  UNION ALL
                  SELECT lt2           AS Tower,
                         playerLeftWin AS Win
                  FROM glade
                  UNION ALL
                  SELECT lt3           AS Tower,
                         playerLeftWin AS Win
                  FROM glade
                  UNION ALL
                  SELECT rt1               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM glade
                  UNION ALL
                  SELECT rt2               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM glade
                  UNION ALL
                  SELECT rt3               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM glade)
            GROUP BY Tower))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;