sun_palace_towers (view)

21 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
EngineerMonkey 540 307 233 56.85% 11.10% 52.67%
MonkeyAce 442 253 189 57.24% 9.08% 52.63%
BananaFarm 1078 594 484 55.10% 22.15% 52.13%
WizardMonkey 391 209 182 53.45% 8.04% 48.51%
BombShooter 77 44 33 57.14% 1.58% 46.09%
BoomerangMonkey 215 109 106 50.70% 4.42% 44.01%
TackShooter 317 156 161 49.21% 6.51% 43.71%
IceMonkey 107 55 52 51.40% 2.20% 41.93%
NinjaMonkey 239 108 131 45.19% 4.91% 38.88%
GlueGunner 168 76 92 45.24% 3.45% 37.71%
MonkeyVillage 232 99 133 42.67% 4.77% 36.31%
DartMonkey 64 31 33 48.44% 1.32% 36.19%
HeliPilot 99 44 55 44.44% 2.03% 34.66%
SpikeFactory 169 68 101 40.24% 3.47% 32.84%
SuperMonkey 176 70 106 39.77% 3.62% 32.54%
Alchemist 79 33 46 41.77% 1.62% 30.90%
DartlingGunner 115 44 71 38.26% 2.36% 29.38%
SniperMonkey 153 56 97 36.60% 3.14% 28.97%
MonkeySub 55 23 32 41.82% 1.13% 28.78%
MortarMonkey 47 20 27 42.55% 0.97% 28.42%
Druid 74 29 45 39.19% 1.52% 28.07%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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