cobra_command_towers (view)

21 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Winrate, Pickrate, Winrate_LowerBound_95CI

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MonkeyAce 51 33 18 64.71% 1.31% 51.59%
SpikeFactory 542 301 241 55.54% 13.92% 51.35%
BananaFarm 902 490 412 54.32% 23.16% 51.07%
BombShooter 600 324 276 54.00% 15.41% 50.01%
DartMonkey 108 64 44 59.26% 2.77% 49.99%
MortarMonkey 71 43 28 60.56% 1.82% 49.20%
EngineerMonkey 103 59 44 57.28% 2.65% 47.73%
BoomerangMonkey 141 78 63 55.32% 3.62% 47.11%
MonkeySub 76 40 36 52.63% 1.95% 41.41%
WizardMonkey 265 117 148 44.15% 6.81% 38.17%
DartlingGunner 116 54 62 46.55% 2.98% 37.47%
SuperMonkey 86 38 48 44.19% 2.21% 33.69%
IceMonkey 46 21 25 45.65% 1.18% 31.26%
Druid 54 24 30 44.44% 1.39% 31.19%
HeliPilot 54 24 30 44.44% 1.39% 31.19%
TackShooter 125 46 79 36.80% 3.21% 28.35%
MonkeyVillage 141 51 90 36.17% 3.62% 28.24%
Alchemist 63 25 38 39.68% 1.62% 27.60%
NinjaMonkey 158 55 103 34.81% 4.06% 27.38%
GlueGunner 83 27 56 32.53% 2.13% 22.45%
SniperMonkey 98 30 68 30.61% 2.52% 21.49%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW cobra_command_towers AS 
WITH cobra_command AS
    (SELECT *
    FROM matches
    WHERE map = 'cobra_command')
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 cobra_command) * 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 cobra_command
                  UNION ALL
                  SELECT lt2           AS Tower,
                         playerLeftWin AS Win
                  FROM cobra_command
                  UNION ALL
                  SELECT lt3           AS Tower,
                         playerLeftWin AS Win
                  FROM cobra_command
                  UNION ALL
                  SELECT rt1               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM cobra_command
                  UNION ALL
                  SELECT rt2               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM cobra_command
                  UNION ALL
                  SELECT rt3               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM cobra_command)
            GROUP BY Tower))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;