times_up_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MortarMonkey 265 155 110 58.49% 3.04% 52.56%
BoomerangMonkey 291 167 124 57.39% 3.34% 51.71%
GlueGunner 394 219 175 55.58% 4.52% 50.68%
TackShooter 1628 861 767 52.89% 18.69% 50.46%
BananaFarm 2157 1131 1026 52.43% 24.76% 50.33%
BombShooter 296 164 132 55.41% 3.40% 49.74%
NinjaMonkey 322 166 156 51.55% 3.70% 46.09%
MonkeySub 762 371 391 48.69% 8.75% 45.14%
IceMonkey 589 285 304 48.39% 6.76% 44.35%
WizardMonkey 816 386 430 47.30% 9.37% 43.88%
MonkeyAce 32 17 15 53.13% 0.37% 35.83%
Druid 110 49 61 44.55% 1.26% 35.26%
SniperMonkey 281 111 170 39.50% 3.23% 33.79%
EngineerMonkey 64 28 36 43.75% 0.73% 31.60%
Alchemist 63 27 36 42.86% 0.72% 30.64%
MonkeyVillage 169 64 105 37.87% 1.94% 30.56%
MonkeyBuccaneer 110 40 70 36.36% 1.26% 27.37%
DartMonkey 49 19 30 38.78% 0.56% 25.13%
SpikeFactory 87 30 57 34.48% 1.00% 24.49%
HeliPilot 80 26 54 32.50% 0.92% 22.24%
SuperMonkey 100 27 73 27.00% 1.15% 18.30%
DartlingGunner 47 13 34 27.66% 0.54% 14.87%

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;