star_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
DartMonkey 4983 2743 2240 55.05% 2.57% 53.67%
IceMonkey 12367 6682 5685 54.03% 6.38% 53.15%
BananaFarm 30875 16445 14430 53.26% 15.93% 52.71%
MonkeySub 13543 7153 6390 52.82% 6.99% 51.98%
BombShooter 6957 3667 3290 52.71% 3.59% 51.54%
MortarMonkey 1936 1030 906 53.20% 1.00% 50.98%
MonkeyAce 2049 1086 963 53.00% 1.06% 50.84%
BoomerangMonkey 5701 2923 2778 51.27% 2.94% 49.97%
TackShooter 14959 7584 7375 50.70% 7.72% 49.90%
GlueGunner 11110 5589 5521 50.31% 5.73% 49.38%
MonkeyVillage 14822 7395 7427 49.89% 7.65% 49.09%
DartlingGunner 7969 3992 3977 50.09% 4.11% 49.00%
EngineerMonkey 3385 1703 1682 50.31% 1.75% 48.63%
WizardMonkey 11784 5735 6049 48.67% 6.08% 47.77%
MonkeyBuccaneer 4161 1996 2165 47.97% 2.15% 46.45%
SpikeFactory 8352 3894 4458 46.62% 4.31% 45.55%
NinjaMonkey 7821 3533 4288 45.17% 4.03% 44.07%
SuperMonkey 8534 3847 4687 45.08% 4.40% 44.02%
Druid 5267 2379 2888 45.17% 2.72% 43.82%
HeliPilot 4240 1890 2350 44.58% 2.19% 43.08%
Alchemist 4322 1918 2404 44.38% 2.23% 42.90%
SniperMonkey 8735 3752 4983 42.95% 4.51% 41.92%

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;