garden_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MortarMonkey 167 103 64 61.68% 1.76% 54.30%
BananaFarm 1617 865 752 53.49% 17.01% 51.06%
DartMonkey 1083 571 512 52.72% 11.40% 49.75%
DartlingGunner 501 267 234 53.29% 5.27% 48.92%
NinjaMonkey 594 314 280 52.86% 6.25% 48.85%
BoomerangMonkey 420 225 195 53.57% 4.42% 48.80%
WizardMonkey 660 344 316 52.12% 6.94% 48.31%
MonkeySub 371 196 175 52.83% 3.90% 47.75%
SniperMonkey 749 380 369 50.73% 7.88% 47.15%
Druid 150 80 70 53.33% 1.58% 45.35%
EngineerMonkey 318 158 160 49.69% 3.35% 44.19%
GlueGunner 347 164 183 47.26% 3.65% 42.01%
Alchemist 213 103 110 48.36% 2.24% 41.65%
SpikeFactory 510 234 276 45.88% 5.37% 41.56%
SuperMonkey 291 135 156 46.39% 3.06% 40.66%
MonkeyVillage 443 185 258 41.76% 4.66% 37.17%
BombShooter 114 52 62 45.61% 1.20% 36.47%
IceMonkey 228 96 132 42.11% 2.40% 35.70%
TackShooter 290 115 175 39.66% 3.05% 34.02%
MonkeyBuccaneer 185 73 112 39.46% 1.95% 32.42%
HeliPilot 158 59 99 37.34% 1.66% 29.80%
MonkeyAce 95 33 62 34.74% 1.00% 25.16%

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;