star_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MonkeyAce 374 221 153 59.09% 1.47% 54.11%
BananaFarm 4633 2443 2190 52.73% 18.17% 51.29%
DartMonkey 461 257 204 55.75% 1.81% 51.21%
IceMonkey 1253 665 588 53.07% 4.91% 50.31%
BombShooter 1411 739 672 52.37% 5.53% 49.77%
EngineerMonkey 586 314 272 53.58% 2.30% 49.55%
TackShooter 2013 1037 976 51.52% 7.89% 49.33%
MonkeySub 1882 970 912 51.54% 7.38% 49.28%
MortarMonkey 213 119 94 55.87% 0.84% 49.20%
GlueGunner 1276 646 630 50.63% 5.00% 47.88%
BoomerangMonkey 895 453 442 50.61% 3.51% 47.34%
MonkeyVillage 1820 898 922 49.34% 7.14% 47.04%
DartlingGunner 977 472 505 48.31% 3.83% 45.18%
WizardMonkey 1637 764 873 46.67% 6.42% 44.25%
NinjaMonkey 1024 479 545 46.78% 4.02% 43.72%
SpikeFactory 986 452 534 45.84% 3.87% 42.73%
MonkeyBuccaneer 383 182 201 47.52% 1.50% 42.52%
HeliPilot 541 251 290 46.40% 2.12% 42.19%
SuperMonkey 1031 465 566 45.10% 4.04% 42.06%
Druid 765 342 423 44.71% 3.00% 41.18%
Alchemist 493 221 272 44.83% 1.93% 40.44%
SniperMonkey 846 360 486 42.55% 3.32% 39.22%

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;