cobra_command_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MortarMonkey 432 266 166 61.57% 2.44% 56.99%
MonkeyAce 245 153 92 62.45% 1.38% 56.39%
BombShooter 2241 1240 1001 55.33% 12.64% 53.27%
BananaFarm 2977 1627 1350 54.65% 16.79% 52.86%
SpikeFactory 1852 986 866 53.24% 10.45% 50.97%
DartMonkey 885 457 428 51.64% 4.99% 48.35%
MonkeySub 352 182 170 51.70% 1.99% 46.48%
BoomerangMonkey 560 280 280 50.00% 3.16% 45.86%
GlueGunner 1030 503 527 48.83% 5.81% 45.78%
EngineerMonkey 292 146 146 50.00% 1.65% 44.26%
WizardMonkey 924 437 487 47.29% 5.21% 44.08%
DartlingGunner 509 242 267 47.54% 2.87% 43.21%
SuperMonkey 681 304 377 44.64% 3.84% 40.91%
MonkeyVillage 1074 471 603 43.85% 6.06% 40.89%
SniperMonkey 871 381 490 43.74% 4.91% 40.45%
NinjaMonkey 719 314 405 43.67% 4.06% 40.05%
HeliPilot 491 216 275 43.99% 2.77% 39.60%
Alchemist 382 165 217 43.19% 2.15% 38.23%
Druid 268 118 150 44.03% 1.51% 38.09%
TackShooter 606 239 367 39.44% 3.42% 35.55%
IceMonkey 262 108 154 41.22% 1.48% 35.26%
MonkeyBuccaneer 77 30 47 38.96% 0.43% 28.07%

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;