koru_towers (view)

17 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses, Winrate_LowerBound_95CI

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
WizardMonkey 709 398 311 56.14% 21.88% 52.48%
BananaFarm 833 443 390 53.18% 25.71% 49.79%
TackShooter 705 377 328 53.48% 21.76% 49.79%
EngineerMonkey 46 28 18 60.87% 1.42% 46.77%
BoomerangMonkey 140 66 74 47.14% 4.32% 38.87%
MortarMonkey 80 38 42 47.50% 2.47% 36.56%
BombShooter 47 23 24 48.94% 1.45% 34.64%
IceMonkey 48 23 25 47.92% 1.48% 33.78%
NinjaMonkey 81 31 50 38.27% 2.50% 27.69%
SpikeFactory 101 37 64 36.63% 3.12% 27.24%
DartlingGunner 78 29 49 37.18% 2.41% 26.45%
GlueGunner 61 23 38 37.70% 1.88% 25.54%
MonkeySub 26 11 15 42.31% 0.80% 23.32%
SniperMonkey 76 25 51 32.89% 2.35% 22.33%
MonkeyVillage 54 18 36 33.33% 1.67% 20.76%
SuperMonkey 37 12 25 32.43% 1.14% 17.35%
Alchemist 39 11 28 28.21% 1.20% 14.08%

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;