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 1276 720 556 56.43% 4.81% 53.71%
DartMonkey 915 517 398 56.50% 3.45% 53.29%
MonkeyAce 336 196 140 58.33% 1.27% 53.06%
BananaFarm 3376 1824 1552 54.03% 12.73% 52.35%
MonkeySub 1127 612 515 54.30% 4.25% 51.40%
BombShooter 956 498 458 52.09% 3.61% 48.93%
MonkeyVillage 2463 1252 1211 50.83% 9.29% 48.86%
GlueGunner 2031 1034 997 50.91% 7.66% 48.74%
MortarMonkey 370 199 171 53.78% 1.40% 48.70%
EngineerMonkey 452 240 212 53.10% 1.70% 48.50%
TackShooter 2015 1006 1009 49.93% 7.60% 47.74%
BoomerangMonkey 718 368 350 51.25% 2.71% 47.60%
MonkeyBuccaneer 760 378 382 49.74% 2.87% 46.18%
DartlingGunner 1322 638 684 48.26% 4.99% 45.57%
SpikeFactory 1190 572 618 48.07% 4.49% 45.23%
SuperMonkey 1380 636 744 46.09% 5.20% 43.46%
WizardMonkey 1351 614 737 45.45% 5.10% 42.79%
Druid 680 303 377 44.56% 2.56% 40.82%
NinjaMonkey 1038 455 583 43.83% 3.91% 40.82%
HeliPilot 805 355 450 44.10% 3.04% 40.67%
Alchemist 675 296 379 43.85% 2.55% 40.11%
SniperMonkey 1278 544 734 42.57% 4.82% 39.86%

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;