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 300 186 114 62.00% 2.71% 56.51%
DartMonkey 1627 894 733 54.95% 14.68% 52.53%
BananaFarm 1796 953 843 53.06% 16.21% 50.75%
MonkeySub 585 309 276 52.82% 5.28% 48.78%
MonkeyAce 188 104 84 55.32% 1.70% 48.21%
SniperMonkey 668 346 322 51.80% 6.03% 48.01%
MonkeyVillage 658 325 333 49.39% 5.94% 45.57%
NinjaMonkey 547 272 275 49.73% 4.94% 45.54%
GlueGunner 764 373 391 48.82% 6.89% 45.28%
BoomerangMonkey 389 195 194 50.13% 3.51% 45.16%
DartlingGunner 422 205 217 48.58% 3.81% 43.81%
SpikeFactory 446 215 231 48.21% 4.02% 43.57%
Druid 272 132 140 48.53% 2.45% 42.59%
MonkeyBuccaneer 189 89 100 47.09% 1.71% 39.97%
Alchemist 235 108 127 45.96% 2.12% 39.59%
IceMonkey 191 87 104 45.55% 1.72% 38.49%
WizardMonkey 544 227 317 41.73% 4.91% 37.58%
BombShooter 209 92 117 44.02% 1.89% 37.29%
EngineerMonkey 244 103 141 42.21% 2.20% 36.02%
TackShooter 293 122 171 41.64% 2.64% 35.99%
SuperMonkey 348 142 206 40.80% 3.14% 35.64%
HeliPilot 167 62 105 37.13% 1.51% 29.80%

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;