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 265 185 80 69.81% 2.46% 64.28%
DartMonkey 1263 708 555 56.06% 11.74% 53.32%
MonkeyAce 162 97 65 59.88% 1.51% 52.33%
BananaFarm 1986 1026 960 51.66% 18.46% 49.46%
MonkeySub 932 473 459 50.75% 8.66% 47.54%
BoomerangMonkey 452 234 218 51.77% 4.20% 47.16%
Druid 289 146 143 50.52% 2.69% 44.75%
EngineerMonkey 229 117 112 51.09% 2.13% 44.62%
NinjaMonkey 603 293 310 48.59% 5.61% 44.60%
SniperMonkey 707 341 366 48.23% 6.57% 44.55%
SpikeFactory 473 227 246 47.99% 4.40% 43.49%
MonkeyVillage 392 185 207 47.19% 3.64% 42.25%
GlueGunner 464 217 247 46.77% 4.31% 42.23%
Alchemist 181 88 93 48.62% 1.68% 41.34%
WizardMonkey 575 260 315 45.22% 5.34% 41.15%
MonkeyBuccaneer 171 83 88 48.54% 1.59% 41.05%
IceMonkey 398 178 220 44.72% 3.70% 39.84%
DartlingGunner 359 161 198 44.85% 3.34% 39.70%
TackShooter 345 147 198 42.61% 3.21% 37.39%
BombShooter 161 71 90 44.10% 1.50% 36.43%
SuperMonkey 246 104 142 42.28% 2.29% 36.10%
HeliPilot 105 38 67 36.19% 0.98% 27.00%

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;