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 1539 903 636 58.67% 7.54% 56.21%
EngineerMonkey 1471 848 623 57.65% 7.21% 55.12%
BananaFarm 3404 1851 1553 54.38% 16.69% 52.70%
SpikeFactory 1043 527 516 50.53% 5.11% 47.49%
MonkeySub 890 451 439 50.67% 4.36% 47.39%
BombShooter 275 145 130 52.73% 1.35% 46.83%
Druid 675 340 335 50.37% 3.31% 46.60%
DartlingGunner 1294 638 656 49.30% 6.34% 46.58%
WizardMonkey 1301 628 673 48.27% 6.38% 45.56%
MonkeyVillage 1454 698 756 48.01% 7.13% 45.44%
BoomerangMonkey 705 345 360 48.94% 3.46% 45.25%
SuperMonkey 1109 514 595 46.35% 5.44% 43.41%
IceMonkey 619 287 332 46.37% 3.03% 42.44%
MortarMonkey 99 51 48 51.52% 0.49% 41.67%
TackShooter 603 275 328 45.61% 2.96% 41.63%
NinjaMonkey 824 370 454 44.90% 4.04% 41.51%
MonkeyBuccaneer 339 158 181 46.61% 1.66% 41.30%
DartMonkey 333 153 180 45.95% 1.63% 40.59%
SniperMonkey 972 416 556 42.80% 4.76% 39.69%
Alchemist 473 204 269 43.13% 2.32% 38.67%
HeliPilot 467 191 276 40.90% 2.29% 36.44%
GlueGunner 511 207 304 40.51% 2.50% 36.25%

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;