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 352 212 140 60.23% 2.92% 55.11%
BananaFarm 1468 801 667 54.56% 12.20% 52.02%
DartMonkey 1848 998 850 54.00% 15.35% 51.73%
MonkeyAce 131 75 56 57.25% 1.09% 48.78%
BoomerangMonkey 335 180 155 53.73% 2.78% 48.39%
DartlingGunner 521 270 251 51.82% 4.33% 47.53%
SniperMonkey 940 472 468 50.21% 7.81% 47.02%
GlueGunner 961 471 490 49.01% 7.98% 45.85%
BombShooter 191 98 93 51.31% 1.59% 44.22%
WizardMonkey 574 277 297 48.26% 4.77% 44.17%
NinjaMonkey 630 302 328 47.94% 5.23% 44.04%
MonkeyVillage 722 344 378 47.65% 6.00% 44.00%
MonkeySub 356 174 182 48.88% 2.96% 43.68%
IceMonkey 196 99 97 50.51% 1.63% 43.51%
MonkeyBuccaneer 396 189 207 47.73% 3.29% 42.81%
Alchemist 390 180 210 46.15% 3.24% 41.21%
SuperMonkey 501 225 276 44.91% 4.16% 40.55%
SpikeFactory 543 239 304 44.01% 4.51% 39.84%
Druid 269 120 149 44.61% 2.23% 38.67%
TackShooter 299 131 168 43.81% 2.48% 38.19%
EngineerMonkey 215 93 122 43.26% 1.79% 36.63%
HeliPilot 198 68 130 34.34% 1.65% 27.73%

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;