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 210 146 64 69.52% 2.10% 63.30%
DartMonkey 1150 618 532 53.74% 11.48% 50.86%
BananaFarm 1783 934 849 52.38% 17.79% 50.07%
MonkeySub 665 357 308 53.68% 6.64% 49.89%
BoomerangMonkey 432 220 212 50.93% 4.31% 46.21%
MonkeyAce 123 67 56 54.47% 1.23% 45.67%
SniperMonkey 772 376 396 48.70% 7.70% 45.18%
DartlingGunner 387 194 193 50.13% 3.86% 45.15%
SpikeFactory 472 232 240 49.15% 4.71% 44.64%
NinjaMonkey 634 307 327 48.42% 6.33% 44.53%
GlueGunner 420 205 215 48.81% 4.19% 44.03%
Druid 153 79 74 51.63% 1.53% 43.72%
MonkeyVillage 397 193 204 48.61% 3.96% 43.70%
WizardMonkey 574 266 308 46.34% 5.73% 42.26%
EngineerMonkey 204 100 104 49.02% 2.04% 42.16%
IceMonkey 404 190 214 47.03% 4.03% 42.16%
MonkeyBuccaneer 206 96 110 46.60% 2.06% 39.79%
SuperMonkey 269 122 147 45.35% 2.68% 39.40%
Alchemist 178 81 97 45.51% 1.78% 38.19%
TackShooter 313 118 195 37.70% 3.12% 32.33%
HeliPilot 142 57 85 40.14% 1.42% 32.08%
BombShooter 132 52 80 39.39% 1.32% 31.06%

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;