koru_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
WizardMonkey 1881 1034 847 54.97% 17.08% 52.72%
BananaFarm 2689 1444 1245 53.70% 24.41% 51.82%
TackShooter 2077 1113 964 53.59% 18.85% 51.44%
MonkeyAce 144 79 65 54.86% 1.31% 46.73%
DartlingGunner 236 124 112 52.54% 2.14% 46.17%
BoomerangMonkey 444 209 235 47.07% 4.03% 42.43%
NinjaMonkey 385 182 203 47.27% 3.49% 42.29%
SpikeFactory 364 166 198 45.60% 3.30% 40.49%
IceMonkey 326 149 177 45.71% 2.96% 40.30%
MortarMonkey 278 128 150 46.04% 2.52% 40.18%
BombShooter 224 103 121 45.98% 2.03% 39.46%
EngineerMonkey 131 62 69 47.33% 1.19% 38.78%
GlueGunner 276 121 155 43.84% 2.51% 37.99%
MonkeySub 270 112 158 41.48% 2.45% 35.60%
MonkeyVillage 244 100 144 40.98% 2.21% 34.81%
SniperMonkey 419 163 256 38.90% 3.80% 34.23%
Druid 130 48 82 36.92% 1.18% 28.63%
HeliPilot 109 41 68 37.61% 0.99% 28.52%
DartMonkey 91 33 58 36.26% 0.83% 26.39%
SuperMonkey 167 56 111 33.53% 1.52% 26.37%
Alchemist 87 27 60 31.03% 0.79% 21.31%
MonkeyBuccaneer 44 14 30 31.82% 0.40% 18.06%

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;