up_on_the_roof_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Winrate

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MortarMonkey 227 144 83 63.44% 1.65% 57.17%
MonkeyVillage 1884 1046 838 55.52% 13.68% 53.28%
IceMonkey 542 309 233 57.01% 3.93% 52.84%
DartMonkey 560 305 255 54.46% 4.07% 50.34%
SuperMonkey 1616 843 773 52.17% 11.73% 49.73%
HeliPilot 661 341 320 51.59% 4.80% 47.78%
GlueGunner 890 454 436 51.01% 6.46% 47.73%
DartlingGunner 757 387 370 51.12% 5.50% 47.56%
TackShooter 795 387 408 48.68% 5.77% 45.20%
BananaFarm 1008 473 535 46.92% 7.32% 43.84%
SpikeFactory 670 318 352 47.46% 4.86% 43.68%
SniperMonkey 934 431 503 46.15% 6.78% 42.95%
BoomerangMonkey 367 170 197 46.32% 2.66% 41.22%
NinjaMonkey 646 290 356 44.89% 4.69% 41.06%
Druid 268 126 142 47.01% 1.95% 41.04%
Alchemist 355 164 191 46.20% 2.58% 41.01%
WizardMonkey 766 331 435 43.21% 5.56% 39.70%
EngineerMonkey 182 84 98 46.15% 1.32% 38.91%
MonkeySub 159 74 85 46.54% 1.15% 38.79%
BombShooter 230 103 127 44.78% 1.67% 38.36%
MonkeyAce 124 52 72 41.94% 0.90% 33.25%
MonkeyBuccaneer 135 56 79 41.48% 0.98% 33.17%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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