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 2260 1238 1022 54.78% 17.71% 52.73%
BananaFarm 3173 1720 1453 54.21% 24.86% 52.47%
TackShooter 2535 1341 1194 52.90% 19.86% 50.96%
MonkeyAce 118 68 50 57.63% 0.92% 48.71%
BombShooter 252 129 123 51.19% 1.97% 45.02%
DartlingGunner 203 105 98 51.72% 1.59% 44.85%
MortarMonkey 353 172 181 48.73% 2.77% 43.51%
SpikeFactory 395 185 210 46.84% 3.10% 41.91%
BoomerangMonkey 488 226 262 46.31% 3.82% 41.89%
MonkeySub 379 166 213 43.80% 2.97% 38.80%
IceMonkey 293 129 164 44.03% 2.30% 38.34%
GlueGunner 318 137 181 43.08% 2.49% 37.64%
EngineerMonkey 141 63 78 44.68% 1.10% 36.47%
Druid 177 77 100 43.50% 1.39% 36.20%
NinjaMonkey 449 180 269 40.09% 3.52% 35.56%
SniperMonkey 507 192 315 37.87% 3.97% 33.65%
SuperMonkey 159 62 97 38.99% 1.25% 31.41%
MonkeyVillage 223 82 141 36.77% 1.75% 30.44%
MonkeyBuccaneer 57 21 36 36.84% 0.45% 24.32%
Alchemist 106 35 71 33.02% 0.83% 24.07%
DartMonkey 96 30 66 31.25% 0.75% 21.98%
HeliPilot 80 23 57 28.75% 0.63% 18.83%

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;