splashdown_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses, Pickrate

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
NinjaMonkey 108 64 44 59.26% 3.64% 49.99%
BananaFarm 382 210 172 54.97% 12.89% 49.98%
Druid 48 30 18 62.50% 1.62% 48.80%
BombShooter 49 30 19 61.22% 1.65% 47.58%
MonkeySub 351 175 176 49.86% 11.84% 44.63%
MonkeyBuccaneer 288 141 147 48.96% 9.72% 43.18%
BoomerangMonkey 126 65 61 51.59% 4.25% 42.86%
WizardMonkey 173 87 86 50.29% 5.84% 42.84%
Alchemist 150 76 74 50.67% 5.06% 42.67%
IceMonkey 218 107 111 49.08% 7.35% 42.45%
MortarMonkey 64 34 30 53.13% 2.16% 40.90%
TackShooter 117 58 59 49.57% 3.95% 40.51%
SpikeFactory 221 103 118 46.61% 7.46% 40.03%
MonkeyVillage 111 54 57 48.65% 3.74% 39.35%
DartMonkey 55 28 27 50.91% 1.86% 37.70%
MonkeyAce 66 32 34 48.48% 2.23% 36.43%
HeliPilot 109 48 61 44.04% 3.68% 34.72%
EngineerMonkey 58 27 31 46.55% 1.96% 33.71%
SuperMonkey 58 26 32 44.83% 1.96% 32.03%
DartlingGunner 35 17 18 48.57% 1.18% 32.01%
SniperMonkey 111 45 66 40.54% 3.74% 31.41%
GlueGunner 66 25 41 37.88% 2.23% 26.18%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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