glade_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
DartMonkey 1032 585 447 56.69% 11.29% 53.66%
BananaFarm 1970 1085 885 55.08% 21.56% 52.88%
SpikeFactory 1303 696 607 53.42% 14.26% 50.71%
MortarMonkey 142 83 59 58.45% 1.55% 50.35%
DartlingGunner 442 222 220 50.23% 4.84% 45.56%
BoomerangMonkey 554 272 282 49.10% 6.06% 44.93%
TackShooter 407 196 211 48.16% 4.45% 43.30%
WizardMonkey 758 350 408 46.17% 8.30% 42.63%
SuperMonkey 230 112 118 48.70% 2.52% 42.24%
HeliPilot 152 75 77 49.34% 1.66% 41.39%
IceMonkey 185 88 97 47.57% 2.02% 40.37%
EngineerMonkey 160 75 85 46.88% 1.75% 39.14%
MonkeySub 214 96 118 44.86% 2.34% 38.20%
SniperMonkey 403 166 237 41.19% 4.41% 36.39%
NinjaMonkey 296 124 172 41.89% 3.24% 36.27%
Alchemist 180 76 104 42.22% 1.97% 35.01%
MonkeyVillage 245 96 149 39.18% 2.68% 33.07%
MonkeyBuccaneer 120 49 71 40.83% 1.31% 32.04%
Druid 69 27 42 39.13% 0.76% 27.61%
GlueGunner 146 51 95 34.93% 1.60% 27.20%
BombShooter 73 27 46 36.99% 0.80% 25.91%
MonkeyAce 57 18 39 31.58% 0.62% 19.51%

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;