star_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
DartlingGunner 394 220 174 55.84% 6.38% 50.93%
WizardMonkey 421 231 190 54.87% 6.81% 50.12%
TackShooter 466 254 212 54.51% 7.54% 49.99%
BananaFarm 1261 661 600 52.42% 20.40% 49.66%
SpikeFactory 215 114 101 53.02% 3.48% 46.35%
IceMonkey 480 242 238 50.42% 7.77% 45.94%
NinjaMonkey 313 161 152 51.44% 5.06% 45.90%
BombShooter 189 95 94 50.26% 3.06% 43.14%
EngineerMonkey 117 60 57 51.28% 1.89% 42.22%
MonkeySub 510 235 275 46.08% 8.25% 41.75%
MonkeyVillage 388 181 207 46.65% 6.28% 41.69%
Alchemist 99 50 49 50.51% 1.60% 40.66%
DartMonkey 61 32 29 52.46% 0.99% 39.93%
HeliPilot 101 50 51 49.50% 1.63% 39.75%
GlueGunner 208 94 114 45.19% 3.37% 38.43%
Druid 147 65 82 44.22% 2.38% 36.19%
BoomerangMonkey 174 75 99 43.10% 2.82% 35.75%
MonkeyAce 53 26 27 49.06% 0.86% 35.60%
SuperMonkey 269 111 158 41.26% 4.35% 35.38%
SniperMonkey 196 80 116 40.82% 3.17% 33.94%
MonkeyBuccaneer 93 40 53 43.01% 1.50% 32.95%
MortarMonkey 25 13 12 52.00% 0.40% 32.42%

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;