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 254 155 99 61.02% 1.00% 55.03%
DartMonkey 1024 590 434 57.62% 4.05% 54.59%
BananaFarm 2954 1623 1331 54.94% 11.67% 53.15%
BombShooter 965 534 431 55.34% 3.81% 52.20%
MortarMonkey 305 175 130 57.38% 1.21% 51.83%
IceMonkey 1154 627 527 54.33% 4.56% 51.46%
MonkeySub 1044 547 497 52.39% 4.13% 49.37%
BoomerangMonkey 715 376 339 52.59% 2.83% 48.93%
TackShooter 1851 935 916 50.51% 7.32% 48.24%
GlueGunner 1960 985 975 50.26% 7.75% 48.04%
EngineerMonkey 416 218 198 52.40% 1.64% 47.60%
MonkeyVillage 2533 1251 1282 49.39% 10.01% 47.44%
MonkeyBuccaneer 679 339 340 49.93% 2.68% 46.17%
WizardMonkey 1334 642 692 48.13% 5.27% 45.44%
DartlingGunner 930 448 482 48.17% 3.68% 44.96%
SpikeFactory 1400 648 752 46.29% 5.53% 43.67%
NinjaMonkey 1136 523 613 46.04% 4.49% 43.14%
SuperMonkey 1170 523 647 44.70% 4.62% 41.85%
SniperMonkey 1350 588 762 43.56% 5.34% 40.91%
Druid 881 387 494 43.93% 3.48% 40.65%
Alchemist 732 315 417 43.03% 2.89% 39.45%
HeliPilot 515 222 293 43.11% 2.04% 38.83%

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;