koru_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
BananaFarm 2899 1590 1309 54.85% 23.24% 53.03%
TackShooter 2267 1248 1019 55.05% 18.17% 53.00%
WizardMonkey 1873 1005 868 53.66% 15.02% 51.40%
MonkeyAce 124 72 52 58.06% 0.99% 49.38%
IceMonkey 446 229 217 51.35% 3.58% 46.71%
BoomerangMonkey 647 314 333 48.53% 5.19% 44.68%
MortarMonkey 390 191 199 48.97% 3.13% 44.01%
MonkeySub 270 131 139 48.52% 2.16% 42.56%
BombShooter 291 138 153 47.42% 2.33% 41.69%
DartlingGunner 242 115 127 47.52% 1.94% 41.23%
DartMonkey 137 67 70 48.91% 1.10% 40.53%
SpikeFactory 463 192 271 41.47% 3.71% 36.98%
GlueGunner 429 175 254 40.79% 3.44% 36.14%
EngineerMonkey 171 72 99 42.11% 1.37% 34.71%
SniperMonkey 400 158 242 39.50% 3.21% 34.71%
MonkeyVillage 306 123 183 40.20% 2.45% 34.70%
Druid 203 84 119 41.38% 1.63% 34.60%
NinjaMonkey 433 169 264 39.03% 3.47% 34.44%
SuperMonkey 207 73 134 35.27% 1.66% 28.76%
HeliPilot 120 43 77 35.83% 0.96% 27.25%
MonkeyBuccaneer 62 23 39 37.10% 0.50% 25.07%
Alchemist 94 25 69 26.60% 0.75% 17.66%

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;