dino_graveyard_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MonkeyAce 1061 652 409 61.45% 5.96% 58.52%
EngineerMonkey 981 598 383 60.96% 5.51% 57.91%
BananaFarm 3345 1825 1520 54.56% 18.79% 52.87%
MonkeySub 1366 747 619 54.69% 7.67% 52.05%
Druid 570 306 264 53.68% 3.20% 49.59%
IceMonkey 855 428 427 50.06% 4.80% 46.71%
WizardMonkey 1061 501 560 47.22% 5.96% 44.22%
NinjaMonkey 851 397 454 46.65% 4.78% 43.30%
DartlingGunner 988 456 532 46.15% 5.55% 43.05%
MonkeyVillage 1005 460 545 45.77% 5.65% 42.69%
SuperMonkey 701 325 376 46.36% 3.94% 42.67%
SpikeFactory 894 408 486 45.64% 5.02% 42.37%
BoomerangMonkey 614 280 334 45.60% 3.45% 41.66%
DartMonkey 257 122 135 47.47% 1.44% 41.37%
BombShooter 322 149 173 46.27% 1.81% 40.83%
SniperMonkey 851 374 477 43.95% 4.78% 40.61%
Alchemist 414 182 232 43.96% 2.33% 39.18%
HeliPilot 322 141 181 43.79% 1.81% 38.37%
GlueGunner 432 180 252 41.67% 2.43% 37.02%
TackShooter 597 239 358 40.03% 3.35% 36.10%
MonkeyBuccaneer 225 92 133 40.89% 1.26% 34.46%
MortarMonkey 90 39 51 43.33% 0.51% 33.10%

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;