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
MonkeyAce 927 570 357 61.49% 4.85% 58.36%
EngineerMonkey 725 430 295 59.31% 3.79% 55.73%
MonkeySub 714 415 299 58.12% 3.74% 54.50%
BananaFarm 2429 1367 1062 56.28% 12.71% 54.31%
Druid 851 451 400 53.00% 4.45% 49.64%
MortarMonkey 208 114 94 54.81% 1.09% 48.04%
IceMonkey 464 243 221 52.37% 2.43% 47.83%
DartMonkey 770 384 386 49.87% 4.03% 46.34%
BoomerangMonkey 582 291 291 50.00% 3.04% 45.94%
SpikeFactory 1345 651 694 48.40% 7.04% 45.73%
SniperMonkey 1128 546 582 48.40% 5.90% 45.49%
Alchemist 725 356 369 49.10% 3.79% 45.46%
DartlingGunner 1047 498 549 47.56% 5.48% 44.54%
MonkeyVillage 1341 617 724 46.01% 7.02% 43.34%
HeliPilot 425 204 221 48.00% 2.22% 43.25%
WizardMonkey 1017 471 546 46.31% 5.32% 43.25%
BombShooter 395 190 205 48.10% 2.07% 43.17%
TackShooter 552 254 298 46.01% 2.89% 41.86%
GlueGunner 1099 476 623 43.31% 5.75% 40.38%
SuperMonkey 998 431 567 43.19% 5.22% 40.11%
MonkeyBuccaneer 480 213 267 44.38% 2.51% 39.93%
NinjaMonkey 894 386 508 43.18% 4.68% 39.93%

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;