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 1252 729 523 58.23% 12.27% 55.49%
BananaFarm 2231 1215 1016 54.46% 21.86% 52.39%
SpikeFactory 1557 844 713 54.21% 15.26% 51.73%
MortarMonkey 240 131 109 54.58% 2.35% 48.28%
MonkeySub 344 171 173 49.71% 3.37% 44.43%
BoomerangMonkey 833 389 444 46.70% 8.16% 43.31%
WizardMonkey 627 283 344 45.14% 6.14% 41.24%
GlueGunner 309 144 165 46.60% 3.03% 41.04%
TackShooter 402 182 220 45.27% 3.94% 40.41%
MonkeyBuccaneer 124 61 63 49.19% 1.21% 40.39%
SniperMonkey 394 177 217 44.92% 3.86% 40.01%
BombShooter 134 63 71 47.01% 1.31% 38.56%
DartlingGunner 299 129 170 43.14% 2.93% 37.53%
Alchemist 170 73 97 42.94% 1.67% 35.50%
IceMonkey 118 52 66 44.07% 1.16% 35.11%
NinjaMonkey 294 116 178 39.46% 2.88% 33.87%
MonkeyVillage 251 100 151 39.84% 2.46% 33.78%
SuperMonkey 186 75 111 40.32% 1.82% 33.27%
Druid 125 52 73 41.60% 1.22% 32.96%
EngineerMonkey 154 59 95 38.31% 1.51% 30.63%
MonkeyAce 56 24 32 42.86% 0.55% 29.90%
HeliPilot 106 34 72 32.08% 1.04% 23.19%

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;