dino_graveyard_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
EngineerMonkey 1036 642 394 61.97% 5.63% 59.01%
MonkeyAce 1126 682 444 60.57% 6.12% 57.71%
BananaFarm 3600 1998 1602 55.50% 19.58% 53.88%
BoomerangMonkey 648 350 298 54.01% 3.52% 50.17%
MonkeySub 1675 878 797 52.42% 9.11% 50.03%
Druid 810 419 391 51.73% 4.40% 48.29%
IceMonkey 832 416 416 50.00% 4.52% 46.60%
MortarMonkey 124 68 56 54.84% 0.67% 46.08%
WizardMonkey 1028 494 534 48.05% 5.59% 45.00%
BombShooter 351 174 177 49.57% 1.91% 44.34%
NinjaMonkey 772 368 404 47.67% 4.20% 44.15%
DartMonkey 304 148 156 48.68% 1.65% 43.07%
DartlingGunner 884 382 502 43.21% 4.81% 39.95%
SpikeFactory 1002 431 571 43.01% 5.45% 39.95%
MonkeyVillage 860 363 497 42.21% 4.68% 38.91%
TackShooter 511 219 292 42.86% 2.78% 38.57%
SniperMonkey 757 317 440 41.88% 4.12% 38.36%
SuperMonkey 693 287 406 41.41% 3.77% 37.75%
MonkeyBuccaneer 293 125 168 42.66% 1.59% 37.00%
Alchemist 411 169 242 41.12% 2.23% 36.36%
GlueGunner 420 166 254 39.52% 2.28% 34.85%
HeliPilot 253 99 154 39.13% 1.38% 33.12%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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