glade_towers (view)

17 rows

✎ View and edit SQL

This data as json, CSV (advanced)

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

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
NinjaMonkey 99 61 38 61.62% 3.83% 52.04%
BananaFarm 643 348 295 54.12% 24.86% 50.27%
DartlingGunner 127 71 56 55.91% 4.91% 47.27%
DartMonkey 343 179 164 52.19% 13.26% 46.90%
SpikeFactory 430 218 212 50.70% 16.63% 45.97%
TackShooter 113 61 52 53.98% 4.37% 44.79%
IceMonkey 30 18 12 60.00% 1.16% 42.47%
BoomerangMonkey 167 80 87 47.90% 6.46% 40.33%
WizardMonkey 193 91 102 47.15% 7.46% 40.11%
MortarMonkey 45 24 21 53.33% 1.74% 38.76%
EngineerMonkey 27 14 13 51.85% 1.04% 33.00%
HeliPilot 27 14 13 51.85% 1.04% 33.00%
SniperMonkey 66 28 38 42.42% 2.55% 30.50%
Alchemist 49 19 30 38.78% 1.89% 25.13%
SuperMonkey 41 15 26 36.59% 1.59% 21.84%
MonkeySub 41 13 28 31.71% 1.59% 17.46%
MonkeyVillage 39 12 27 30.77% 1.51% 16.28%

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;