sun_palace_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Losses

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
EngineerMonkey 1096 655 441 59.76% 5.86% 56.86%
MonkeyAce 966 554 412 57.35% 5.17% 54.23%
BananaFarm 2988 1622 1366 54.28% 15.98% 52.50%
BoomerangMonkey 647 359 288 55.49% 3.46% 51.66%
DartMonkey 674 373 301 55.34% 3.61% 51.59%
MonkeyVillage 1361 706 655 51.87% 7.28% 49.22%
GlueGunner 1355 700 655 51.66% 7.25% 49.00%
MortarMonkey 312 168 144 53.85% 1.67% 48.31%
HeliPilot 713 358 355 50.21% 3.81% 46.54%
TackShooter 1131 542 589 47.92% 6.05% 45.01%
IceMonkey 624 298 326 47.76% 3.34% 43.84%
WizardMonkey 1165 543 622 46.61% 6.23% 43.74%
BombShooter 483 228 255 47.20% 2.58% 42.75%
NinjaMonkey 878 403 475 45.90% 4.70% 42.60%
SpikeFactory 663 297 366 44.80% 3.55% 41.01%
SuperMonkey 949 415 534 43.73% 5.08% 40.57%
MonkeySub 350 160 190 45.71% 1.87% 40.50%
SniperMonkey 949 391 558 41.20% 5.08% 38.07%
Druid 377 157 220 41.64% 2.02% 36.67%
DartlingGunner 437 180 257 41.19% 2.34% 36.58%
Alchemist 394 163 231 41.37% 2.11% 36.51%
MonkeyBuccaneer 184 76 108 41.30% 0.98% 34.19%

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;