koru_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Losses

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
BananaFarm 1960 1102 858 56.22% 18.41% 54.03%
IceMonkey 364 213 151 58.52% 3.42% 53.45%
MortarMonkey 458 256 202 55.90% 4.30% 51.35%
TackShooter 1468 790 678 53.81% 13.79% 51.26%
MonkeyAce 134 78 56 58.21% 1.26% 49.86%
WizardMonkey 1099 561 538 51.05% 10.33% 48.09%
BombShooter 382 196 186 51.31% 3.59% 46.30%
BoomerangMonkey 516 254 262 49.22% 4.85% 44.91%
DartlingGunner 302 152 150 50.33% 2.84% 44.69%
SpikeFactory 602 278 324 46.18% 5.66% 42.20%
EngineerMonkey 165 82 83 49.70% 1.55% 42.07%
SniperMonkey 552 246 306 44.57% 5.19% 40.42%
GlueGunner 630 277 353 43.97% 5.92% 40.09%
DartMonkey 296 133 163 44.93% 2.78% 39.27%
Druid 193 86 107 44.56% 1.81% 37.55%
MonkeyVillage 391 162 229 41.43% 3.67% 36.55%
Alchemist 166 73 93 43.98% 1.56% 36.43%
SuperMonkey 274 114 160 41.61% 2.57% 35.77%
MonkeySub 163 70 93 42.94% 1.53% 35.35%
NinjaMonkey 347 135 212 38.90% 3.26% 33.78%
HeliPilot 92 34 58 36.96% 0.86% 27.09%
MonkeyBuccaneer 90 30 60 33.33% 0.85% 23.59%

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;