koru_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
BananaFarm 2825 1501 1324 53.13% 23.30% 51.29%
TackShooter 2370 1257 1113 53.04% 19.54% 51.03%
WizardMonkey 2375 1259 1116 53.01% 19.59% 51.00%
DartlingGunner 354 196 158 55.37% 2.92% 50.19%
EngineerMonkey 186 97 89 52.15% 1.53% 44.97%
BoomerangMonkey 496 243 253 48.99% 4.09% 44.59%
BombShooter 210 106 104 50.48% 1.73% 43.71%
MortarMonkey 247 121 126 48.99% 2.04% 42.75%
SpikeFactory 396 186 210 46.97% 3.27% 42.05%
MonkeyAce 106 53 53 50.00% 0.87% 40.48%
IceMonkey 288 131 157 45.49% 2.38% 39.73%
SuperMonkey 282 128 154 45.39% 2.33% 39.58%
NinjaMonkey 364 158 206 43.41% 3.00% 38.31%
MonkeyVillage 292 128 164 43.84% 2.41% 38.14%
SniperMonkey 413 162 251 39.23% 3.41% 34.52%
MonkeySub 139 58 81 41.73% 1.15% 33.53%
Alchemist 139 57 82 41.01% 1.15% 32.83%
HeliPilot 117 45 72 38.46% 0.96% 29.65%
GlueGunner 229 81 148 35.37% 1.89% 29.18%
DartMonkey 85 29 56 34.12% 0.70% 24.04%
MonkeyBuccaneer 95 31 64 32.63% 0.78% 23.20%
Druid 118 36 82 30.51% 0.97% 22.20%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW koru_towers AS 
WITH koru AS
    (SELECT *
    FROM matches
    WHERE map = 'koru')
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 koru) * 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 koru
                  UNION ALL
                  SELECT lt2           AS Tower,
                         playerLeftWin AS Win
                  FROM koru
                  UNION ALL
                  SELECT lt3           AS Tower,
                         playerLeftWin AS Win
                  FROM koru
                  UNION ALL
                  SELECT rt1               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM koru
                  UNION ALL
                  SELECT rt2               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM koru
                  UNION ALL
                  SELECT rt3               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM koru)
            GROUP BY Tower))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;