sun_palace_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MonkeyAce 8807 5208 3599 59.13% 5.51% 58.11%
EngineerMonkey 9681 5699 3982 58.87% 6.05% 57.89%
MortarMonkey 2384 1362 1022 57.13% 1.49% 55.14%
BananaFarm 26730 14549 12181 54.43% 16.71% 53.83%
BoomerangMonkey 7041 3775 3266 53.61% 4.40% 52.45%
DartMonkey 5665 2958 2707 52.22% 3.54% 50.91%
BombShooter 4402 2227 2175 50.59% 2.75% 49.11%
GlueGunner 10332 5132 5200 49.67% 6.46% 48.71%
MonkeyVillage 11220 5421 5799 48.32% 7.02% 47.39%
IceMonkey 4332 2102 2230 48.52% 2.71% 47.03%
HeliPilot 4450 2133 2317 47.93% 2.78% 46.46%
WizardMonkey 10988 5208 5780 47.40% 6.87% 46.46%
TackShooter 9667 4540 5127 46.96% 6.04% 45.97%
NinjaMonkey 8360 3897 4463 46.61% 5.23% 45.55%
MonkeySub 3118 1440 1678 46.18% 1.95% 44.43%
SpikeFactory 6334 2837 3497 44.79% 3.96% 43.57%
SuperMonkey 6421 2840 3581 44.23% 4.02% 43.02%
SniperMonkey 8073 3509 4564 43.47% 5.05% 42.38%
Alchemist 3675 1611 2064 43.84% 2.30% 42.23%
DartlingGunner 3416 1471 1945 43.06% 2.14% 41.40%
Druid 3408 1459 1949 42.81% 2.13% 41.15%
MonkeyBuccaneer 1420 584 836 41.13% 0.89% 38.57%

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;