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 1438 870 568 60.50% 6.61% 57.97%
EngineerMonkey 1689 998 691 59.09% 7.77% 56.74%
BananaFarm 4075 2188 1887 53.69% 18.74% 52.16%
MortarMonkey 266 145 121 54.51% 1.22% 48.53%
BoomerangMonkey 1066 539 527 50.56% 4.90% 47.56%
GlueGunner 1321 659 662 49.89% 6.08% 47.19%
BombShooter 594 304 290 51.18% 2.73% 47.16%
HeliPilot 753 380 373 50.46% 3.46% 46.89%
MonkeyVillage 1448 697 751 48.14% 6.66% 45.56%
IceMonkey 594 293 301 49.33% 2.73% 45.31%
DartMonkey 542 268 274 49.45% 2.49% 45.24%
TackShooter 1296 601 695 46.37% 5.96% 43.66%
MonkeySub 518 248 270 47.88% 2.38% 43.57%
WizardMonkey 1451 659 792 45.42% 6.67% 42.86%
SpikeFactory 772 346 426 44.82% 3.55% 41.31%
NinjaMonkey 1032 444 588 43.02% 4.75% 40.00%
Alchemist 370 166 204 44.86% 1.70% 39.80%
SuperMonkey 768 331 437 43.10% 3.53% 39.60%
SniperMonkey 873 363 510 41.58% 4.01% 38.31%
Druid 444 188 256 42.34% 2.04% 37.75%
DartlingGunner 275 116 159 42.18% 1.26% 36.34%
MonkeyBuccaneer 159 69 90 43.40% 0.73% 35.69%

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;