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 465 267 198 57.42% 5.77% 52.93%
BananaFarm 1468 798 670 54.36% 18.23% 51.81%
TackShooter 1357 726 631 53.50% 16.85% 50.85%
MortarMonkey 377 208 169 55.17% 4.68% 50.15%
BombShooter 408 208 200 50.98% 5.07% 46.13%
GlueGunner 563 278 285 49.38% 6.99% 45.25%
BoomerangMonkey 224 113 111 50.45% 2.78% 43.90%
WizardMonkey 614 288 326 46.91% 7.63% 42.96%
Alchemist 128 65 63 50.78% 1.59% 42.12%
NinjaMonkey 252 120 132 47.62% 3.13% 41.45%
MonkeySub 418 191 227 45.69% 5.19% 40.92%
DartMonkey 145 69 76 47.59% 1.80% 39.46%
SniperMonkey 373 165 208 44.24% 4.63% 39.20%
MonkeyBuccaneer 216 99 117 45.83% 2.68% 39.19%
DartlingGunner 92 45 47 48.91% 1.14% 38.70%
HeliPilot 73 35 38 47.95% 0.91% 36.48%
MonkeyVillage 310 121 189 39.03% 3.85% 33.60%
EngineerMonkey 88 38 50 43.18% 1.09% 32.83%
SuperMonkey 200 79 121 39.50% 2.48% 32.72%
Druid 124 51 73 41.13% 1.54% 32.47%
SpikeFactory 111 45 66 40.54% 1.38% 31.41%
MonkeyAce 46 17 29 36.96% 0.57% 23.01%

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;