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 1457 955 502 65.55% 7.06% 63.11%
EngineerMonkey 1406 900 506 64.01% 6.81% 61.50%
BananaFarm 3857 2099 1758 54.42% 18.69% 52.85%
MonkeySub 1292 654 638 50.62% 6.26% 47.89%
DartMonkey 392 204 188 52.04% 1.90% 47.10%
MonkeyBuccaneer 396 198 198 50.00% 1.92% 45.08%
Druid 877 424 453 48.35% 4.25% 45.04%
BoomerangMonkey 875 418 457 47.77% 4.24% 44.46%
WizardMonkey 1149 535 614 46.56% 5.57% 43.68%
BombShooter 529 251 278 47.45% 2.56% 43.19%
IceMonkey 437 206 231 47.14% 2.12% 42.46%
SpikeFactory 1045 475 570 45.45% 5.06% 42.44%
Alchemist 546 253 293 46.34% 2.65% 42.15%
TackShooter 585 268 317 45.81% 2.84% 41.77%
DartlingGunner 856 379 477 44.28% 4.15% 40.95%
SniperMonkey 821 364 457 44.34% 3.98% 40.94%
MonkeyVillage 969 419 550 43.24% 4.70% 40.12%
NinjaMonkey 920 394 526 42.83% 4.46% 39.63%
GlueGunner 705 297 408 42.13% 3.42% 38.48%
SuperMonkey 879 361 518 41.07% 4.26% 37.82%
HeliPilot 503 208 295 41.35% 2.44% 37.05%
MortarMonkey 138 55 83 39.86% 0.67% 31.69%

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;