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 2449 1337 1112 54.59% 10.08% 52.62%
BananaFarm 4971 2671 2300 53.73% 20.46% 52.35%
MonkeySub 3122 1682 1440 53.88% 12.85% 52.13%
WizardMonkey 1430 728 702 50.91% 5.88% 48.32%
DartMonkey 300 159 141 53.00% 1.23% 47.35%
BoomerangMonkey 704 354 350 50.28% 2.90% 46.59%
DartlingGunner 878 435 443 49.54% 3.61% 46.24%
EngineerMonkey 462 233 229 50.43% 1.90% 45.87%
BombShooter 876 428 448 48.86% 3.60% 45.55%
TackShooter 1702 813 889 47.77% 7.00% 45.39%
GlueGunner 802 386 416 48.13% 3.30% 44.67%
MonkeyVillage 1313 617 696 46.99% 5.40% 44.29%
MonkeyAce 204 104 100 50.98% 0.84% 44.12%
Druid 689 328 361 47.61% 2.84% 43.88%
SpikeFactory 847 381 466 44.98% 3.49% 41.63%
NinjaMonkey 884 396 488 44.80% 3.64% 41.52%
MortarMonkey 177 83 94 46.89% 0.73% 39.54%
SniperMonkey 946 401 545 42.39% 3.89% 39.24%
HeliPilot 263 110 153 41.83% 1.08% 35.86%
SuperMonkey 654 257 397 39.30% 2.69% 35.55%
MonkeyBuccaneer 296 120 176 40.54% 1.22% 34.95%
Alchemist 331 127 204 38.37% 1.36% 33.13%

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;