times_up_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
IceMonkey 965 577 388 59.79% 10.40% 56.70%
TackShooter 1896 1072 824 56.54% 20.44% 54.31%
BananaFarm 1938 1074 864 55.42% 20.89% 53.20%
BoomerangMonkey 284 150 134 52.82% 3.06% 47.01%
MortarMonkey 374 194 180 51.87% 4.03% 46.81%
WizardMonkey 684 318 366 46.49% 7.37% 42.75%
GlueGunner 437 199 238 45.54% 4.71% 40.87%
NinjaMonkey 265 119 146 44.91% 2.86% 38.92%
MonkeySub 358 156 202 43.58% 3.86% 38.44%
BombShooter 327 135 192 41.28% 3.53% 35.95%
DartMonkey 117 52 65 44.44% 1.26% 35.44%
SniperMonkey 390 155 235 39.74% 4.20% 34.89%
MonkeyBuccaneer 219 84 135 38.36% 2.36% 31.92%
EngineerMonkey 68 29 39 42.65% 0.73% 30.89%
MonkeyVillage 267 97 170 36.33% 2.88% 30.56%
SpikeFactory 84 32 52 38.10% 0.91% 27.71%
HeliPilot 137 48 89 35.04% 1.48% 27.05%
SuperMonkey 155 50 105 32.26% 1.67% 24.90%
Alchemist 89 30 59 33.71% 0.96% 23.89%
Druid 109 32 77 29.36% 1.18% 20.81%
DartlingGunner 60 19 41 31.67% 0.65% 19.90%
MonkeyAce 53 16 37 30.19% 0.57% 17.83%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW times_up_towers AS 
WITH times_up AS
    (SELECT *
    FROM matches
    WHERE map = 'times_up')
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 times_up) * 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 times_up
                  UNION ALL
                  SELECT lt2           AS Tower,
                         playerLeftWin AS Win
                  FROM times_up
                  UNION ALL
                  SELECT lt3           AS Tower,
                         playerLeftWin AS Win
                  FROM times_up
                  UNION ALL
                  SELECT rt1               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM times_up
                  UNION ALL
                  SELECT rt2               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM times_up
                  UNION ALL
                  SELECT rt3               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM times_up)
            GROUP BY Tower))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;