glade_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Winrate

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
DartMonkey 987 567 420 57.45% 10.83% 54.36%
BananaFarm 2082 1109 973 53.27% 22.84% 51.12%
MortarMonkey 157 92 65 58.60% 1.72% 50.89%
SpikeFactory 1406 749 657 53.27% 15.43% 50.66%
EngineerMonkey 91 50 41 54.95% 1.00% 44.72%
DartlingGunner 332 165 167 49.70% 3.64% 44.32%
MonkeySub 409 199 210 48.66% 4.49% 43.81%
WizardMonkey 571 273 298 47.81% 6.27% 43.71%
BoomerangMonkey 629 290 339 46.10% 6.90% 42.21%
NinjaMonkey 347 159 188 45.82% 3.81% 40.58%
IceMonkey 205 96 109 46.83% 2.25% 40.00%
HeliPilot 138 66 72 47.83% 1.51% 39.49%
TackShooter 312 138 174 44.23% 3.42% 38.72%
Druid 105 50 55 47.62% 1.15% 38.07%
Alchemist 174 77 97 44.25% 1.91% 36.87%
SniperMonkey 413 171 242 41.40% 4.53% 36.65%
BombShooter 94 43 51 45.74% 1.03% 35.67%
MonkeyVillage 188 78 110 41.49% 2.06% 34.45%
GlueGunner 174 72 102 41.38% 1.91% 34.06%
SuperMonkey 173 67 106 38.73% 1.90% 31.47%
MonkeyBuccaneer 83 32 51 38.55% 0.91% 28.08%
MonkeyAce 44 14 30 31.82% 0.48% 18.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;