garden_towers (view)

20 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Losses, Winrate, Pickrate

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
IceMonkey 66 44 22 66.67% 2.58% 55.29%
MortarMonkey 58 36 22 62.07% 2.27% 49.58%
DartMonkey 359 196 163 54.60% 14.05% 49.45%
BananaFarm 484 257 227 53.10% 18.94% 48.65%
EngineerMonkey 82 47 35 57.32% 3.21% 46.61%
WizardMonkey 184 98 86 53.26% 7.20% 46.05%
BoomerangMonkey 81 43 38 53.09% 3.17% 42.22%
GlueGunner 81 42 39 51.85% 3.17% 40.97%
TackShooter 65 34 31 52.31% 2.54% 40.17%
SpikeFactory 132 63 69 47.73% 5.16% 39.21%
NinjaMonkey 137 65 72 47.45% 5.36% 39.08%
SniperMonkey 164 74 90 45.12% 6.42% 37.51%
DartlingGunner 109 51 58 46.79% 4.26% 37.42%
MonkeySub 124 56 68 45.16% 4.85% 36.40%
BombShooter 27 14 13 51.85% 1.06% 33.00%
Alchemist 67 30 37 44.78% 2.62% 32.87%
MonkeyVillage 97 41 56 42.27% 3.79% 32.44%
SuperMonkey 90 35 55 38.89% 3.52% 28.82%
MonkeyBuccaneer 60 22 38 36.67% 2.35% 24.47%
Druid 61 21 40 34.43% 2.39% 22.50%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW garden_towers AS 
WITH garden AS
    (SELECT *
    FROM matches
    WHERE map = 'garden')
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 garden) * 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 garden
                  UNION ALL
                  SELECT lt2           AS Tower,
                         playerLeftWin AS Win
                  FROM garden
                  UNION ALL
                  SELECT lt3           AS Tower,
                         playerLeftWin AS Win
                  FROM garden
                  UNION ALL
                  SELECT rt1               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM garden
                  UNION ALL
                  SELECT rt2               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM garden
                  UNION ALL
                  SELECT rt3               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM garden)
            GROUP BY Tower))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;