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 1381 762 619 55.18% 13.86% 52.55%
SpikeFactory 1484 816 668 54.99% 14.89% 52.46%
BananaFarm 1712 935 777 54.61% 17.18% 52.26%
MortarMonkey 301 171 130 56.81% 3.02% 51.21%
IceMonkey 149 83 66 55.70% 1.50% 47.73%
BoomerangMonkey 567 279 288 49.21% 5.69% 45.09%
DartlingGunner 386 183 203 47.41% 3.87% 42.43%
MonkeySub 280 134 146 47.86% 2.81% 42.01%
WizardMonkey 492 224 268 45.53% 4.94% 41.13%
SniperMonkey 473 214 259 45.24% 4.75% 40.76%
MonkeyBuccaneer 226 105 121 46.46% 2.27% 39.96%
Alchemist 296 135 161 45.61% 2.97% 39.93%
TackShooter 266 120 146 45.11% 2.67% 39.13%
SuperMonkey 267 119 148 44.57% 2.68% 38.61%
EngineerMonkey 129 60 69 46.51% 1.29% 37.90%
GlueGunner 485 204 281 42.06% 4.87% 37.67%
MonkeyVillage 307 130 177 42.35% 3.08% 36.82%
NinjaMonkey 263 108 155 41.06% 2.64% 35.12%
BombShooter 152 65 87 42.76% 1.53% 34.90%
HeliPilot 148 63 85 42.57% 1.49% 34.60%
Druid 125 47 78 37.60% 1.25% 29.11%
MonkeyAce 77 26 51 33.77% 0.77% 23.20%

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;