koru_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
IceMonkey 515 303 212 58.83% 5.25% 54.58%
BananaFarm 1968 1092 876 55.49% 20.05% 53.29%
WizardMonkey 1083 587 496 54.20% 11.03% 51.23%
TackShooter 1592 842 750 52.89% 16.22% 50.44%
BoomerangMonkey 497 262 235 52.72% 5.06% 48.33%
DartlingGunner 279 143 136 51.25% 2.84% 45.39%
DartMonkey 151 78 73 51.66% 1.54% 43.68%
EngineerMonkey 192 95 97 49.48% 1.96% 42.41%
MortarMonkey 370 172 198 46.49% 3.77% 41.40%
MonkeyAce 126 63 63 50.00% 1.28% 41.27%
SpikeFactory 450 205 245 45.56% 4.58% 40.95%
MonkeyVillage 321 148 173 46.11% 3.27% 40.65%
BombShooter 247 115 132 46.56% 2.52% 40.34%
SuperMonkey 218 100 118 45.87% 2.22% 39.26%
NinjaMonkey 288 123 165 42.71% 2.93% 37.00%
GlueGunner 523 206 317 39.39% 5.33% 35.20%
SniperMonkey 388 144 244 37.11% 3.95% 32.31%
Alchemist 90 38 52 42.22% 0.92% 32.02%
MonkeySub 174 68 106 39.08% 1.77% 31.83%
HeliPilot 128 49 79 38.28% 1.30% 29.86%
MonkeyBuccaneer 75 30 45 40.00% 0.76% 28.91%
Druid 141 45 96 31.91% 1.44% 24.22%

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;