glade_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
DartMonkey 1228 705 523 57.41% 13.62% 54.64%
BananaFarm 1645 908 737 55.20% 18.24% 52.79%
SpikeFactory 1340 741 599 55.30% 14.86% 52.64%
MortarMonkey 282 164 118 58.16% 3.13% 52.40%
DartlingGunner 382 189 193 49.48% 4.24% 44.46%
BoomerangMonkey 553 267 286 48.28% 6.13% 44.12%
IceMonkey 199 99 100 49.75% 2.21% 42.80%
TackShooter 266 125 141 46.99% 2.95% 40.99%
GlueGunner 403 178 225 44.17% 4.47% 39.32%
SniperMonkey 387 170 217 43.93% 4.29% 38.98%
Alchemist 235 106 129 45.11% 2.61% 38.74%
WizardMonkey 468 199 269 42.52% 5.19% 38.04%
SuperMonkey 208 93 115 44.71% 2.31% 37.95%
MonkeySub 204 89 115 43.63% 2.26% 36.82%
HeliPilot 185 81 104 43.78% 2.05% 36.63%
MonkeyVillage 251 106 145 42.23% 2.78% 36.12%
NinjaMonkey 239 97 142 40.59% 2.65% 34.36%
BombShooter 66 29 37 43.94% 0.73% 31.97%
EngineerMonkey 146 55 91 37.67% 1.62% 29.81%
MonkeyBuccaneer 157 58 99 36.94% 1.74% 29.39%
MonkeyAce 45 15 30 33.33% 0.50% 19.56%
Druid 129 35 94 27.13% 1.43% 19.46%

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;