star_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
IceMonkey 2377 1323 1054 55.66% 10.85% 53.66%
MonkeySub 2544 1380 1164 54.25% 11.62% 52.31%
BananaFarm 4374 2308 2066 52.77% 19.97% 51.29%
DartlingGunner 893 461 432 51.62% 4.08% 48.35%
TackShooter 1635 825 810 50.46% 7.47% 48.04%
MonkeyVillage 1306 659 647 50.46% 5.96% 47.75%
BombShooter 495 254 241 51.31% 2.26% 46.91%
DartMonkey 220 113 107 51.36% 1.00% 44.76%
WizardMonkey 1426 674 752 47.27% 6.51% 44.67%
GlueGunner 748 356 392 47.59% 3.42% 44.01%
EngineerMonkey 330 161 169 48.79% 1.51% 43.39%
BoomerangMonkey 606 283 323 46.70% 2.77% 42.73%
MonkeyAce 189 93 96 49.21% 0.86% 42.08%
SuperMonkey 656 298 358 45.43% 3.00% 41.62%
Druid 423 194 229 45.86% 1.93% 41.11%
NinjaMonkey 948 417 531 43.99% 4.33% 40.83%
MortarMonkey 123 59 64 47.97% 0.56% 39.14%
SniperMonkey 920 386 534 41.96% 4.20% 38.77%
SpikeFactory 743 310 433 41.72% 3.39% 38.18%
HeliPilot 408 173 235 42.40% 1.86% 37.61%
Alchemist 312 129 183 41.35% 1.42% 35.88%
MonkeyBuccaneer 224 94 130 41.96% 1.02% 35.50%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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