dino_graveyard_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MonkeyAce 338 213 125 63.02% 7.88% 57.87%
EngineerMonkey 308 188 120 61.04% 7.18% 55.59%
BananaFarm 774 420 354 54.26% 18.04% 50.75%
Druid 147 84 63 57.14% 3.43% 49.14%
BombShooter 62 37 25 59.68% 1.45% 47.47%
MonkeySub 158 85 73 53.80% 3.68% 46.02%
Alchemist 90 49 41 54.44% 2.10% 44.16%
SpikeFactory 218 109 109 50.00% 5.08% 43.36%
NinjaMonkey 207 103 104 49.76% 4.83% 42.95%
DartlingGunner 404 187 217 46.29% 9.42% 41.42%
WizardMonkey 243 113 130 46.50% 5.66% 40.23%
SuperMonkey 292 125 167 42.81% 6.81% 37.13%
MonkeyVillage 321 135 186 42.06% 7.48% 36.66%
HeliPilot 67 31 36 46.27% 1.56% 34.33%
IceMonkey 73 33 40 45.21% 1.70% 33.79%
MonkeyBuccaneer 46 22 24 47.83% 1.07% 33.39%
BoomerangMonkey 118 49 69 41.53% 2.75% 32.63%
TackShooter 95 40 55 42.11% 2.21% 32.18%
SniperMonkey 141 55 86 39.01% 3.29% 30.96%
DartMonkey 66 28 38 42.42% 1.54% 30.50%
GlueGunner 94 29 65 30.85% 2.19% 21.51%
MortarMonkey 28 10 18 35.71% 0.65% 17.97%

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;