glade_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
BananaFarm 1495 854 641 57.12% 16.80% 54.62%
SpikeFactory 1319 745 574 56.48% 14.82% 53.81%
DartMonkey 1296 721 575 55.63% 14.57% 52.93%
MortarMonkey 259 151 108 58.30% 2.91% 52.30%
BoomerangMonkey 464 237 227 51.08% 5.21% 46.53%
DartlingGunner 329 158 171 48.02% 3.70% 42.63%
Alchemist 266 124 142 46.62% 2.99% 40.62%
MonkeySub 199 92 107 46.23% 2.24% 39.30%
IceMonkey 149 70 79 46.98% 1.67% 38.97%
GlueGunner 494 214 280 43.32% 5.55% 38.95%
SuperMonkey 243 105 138 43.21% 2.73% 36.98%
BombShooter 125 57 68 45.60% 1.40% 36.87%
WizardMonkey 406 168 238 41.38% 4.56% 36.59%
SniperMonkey 492 199 293 40.45% 5.53% 36.11%
MonkeyBuccaneer 166 71 95 42.77% 1.87% 35.24%
NinjaMonkey 271 110 161 40.59% 3.05% 34.74%
MonkeyVillage 302 120 182 39.74% 3.39% 34.22%
EngineerMonkey 106 46 60 43.40% 1.19% 33.96%
MonkeyAce 58 27 31 46.55% 0.65% 33.71%
TackShooter 228 91 137 39.91% 2.56% 33.56%
Druid 129 53 76 41.09% 1.45% 32.60%
HeliPilot 102 36 66 35.29% 1.15% 26.02%

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;