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 1201 751 450 62.53% 6.99% 59.79%
EngineerMonkey 1315 791 524 60.15% 7.66% 57.51%
MortarMonkey 194 115 79 59.28% 1.13% 52.36%
BananaFarm 3421 1845 1576 53.93% 19.92% 52.26%
BoomerangMonkey 994 515 479 51.81% 5.79% 48.70%
NinjaMonkey 1127 550 577 48.80% 6.56% 45.88%
MonkeyVillage 1000 484 516 48.40% 5.82% 45.30%
WizardMonkey 1261 605 656 47.98% 7.34% 45.22%
BombShooter 402 200 202 49.75% 2.34% 44.86%
GlueGunner 671 323 348 48.14% 3.91% 44.36%
TackShooter 1056 492 564 46.59% 6.15% 43.58%
DartMonkey 255 125 130 49.02% 1.48% 42.88%
IceMonkey 570 263 307 46.14% 3.32% 42.05%
SpikeFactory 596 254 342 42.62% 3.47% 38.65%
HeliPilot 405 174 231 42.96% 2.36% 38.14%
SuperMonkey 480 200 280 41.67% 2.80% 37.26%
SniperMonkey 879 355 524 40.39% 5.12% 37.14%
DartlingGunner 402 167 235 41.54% 2.34% 36.72%
Alchemist 335 140 195 41.79% 1.95% 36.51%
MonkeySub 329 137 192 41.64% 1.92% 36.31%
Druid 219 80 139 36.53% 1.28% 30.15%
MonkeyBuccaneer 60 20 40 33.33% 0.35% 21.41%

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;