garden_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Pickrate

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MortarMonkey 292 175 117 59.93% 3.02% 54.31%
DartMonkey 1493 827 666 55.39% 15.46% 52.87%
BananaFarm 1341 707 634 52.72% 13.88% 50.05%
GlueGunner 860 456 404 53.02% 8.90% 49.69%
BoomerangMonkey 365 192 173 52.60% 3.78% 47.48%
MonkeyVillage 636 319 317 50.16% 6.58% 46.27%
MonkeySub 278 142 136 51.08% 2.88% 45.20%
SniperMonkey 624 303 321 48.56% 6.46% 44.64%
SpikeFactory 438 213 225 48.63% 4.53% 43.95%
MonkeyBuccaneer 221 109 112 49.32% 2.29% 42.73%
DartlingGunner 417 198 219 47.48% 4.32% 42.69%
Alchemist 238 115 123 48.32% 2.46% 41.97%
NinjaMonkey 489 225 264 46.01% 5.06% 41.59%
HeliPilot 192 91 101 47.40% 1.99% 40.33%
Druid 159 76 83 47.80% 1.65% 40.03%
IceMonkey 220 100 120 45.45% 2.28% 38.87%
TackShooter 243 105 138 43.21% 2.52% 36.98%
WizardMonkey 424 173 251 40.80% 4.39% 36.12%
EngineerMonkey 159 68 91 42.77% 1.65% 35.08%
SuperMonkey 367 147 220 40.05% 3.80% 35.04%
BombShooter 121 52 69 42.98% 1.25% 34.15%
MonkeyAce 83 37 46 44.58% 0.86% 33.88%

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;