neo_highway_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MortarMonkey 79 49 30 62.03% 2.13% 51.32%
BananaFarm 527 291 236 55.22% 14.19% 50.97%
DartMonkey 395 208 187 52.66% 10.64% 47.73%
SpikeFactory 540 280 260 51.85% 14.54% 47.64%
IceMonkey 45 27 18 60.00% 1.21% 45.69%
BoomerangMonkey 132 70 62 53.03% 3.55% 44.52%
DartlingGunner 350 174 176 49.71% 9.42% 44.48%
HeliPilot 110 58 52 52.73% 2.96% 43.40%
GlueGunner 204 101 103 49.51% 5.49% 42.65%
TackShooter 49 27 22 55.10% 1.32% 41.18%
SuperMonkey 148 72 76 48.65% 3.98% 40.60%
EngineerMonkey 69 36 33 52.17% 1.86% 40.39%
SniperMonkey 214 99 115 46.26% 5.76% 39.58%
NinjaMonkey 100 48 52 48.00% 2.69% 38.21%
Alchemist 173 78 95 45.09% 4.66% 37.67%
MonkeyVillage 145 62 83 42.76% 3.90% 34.71%
MonkeySub 74 34 40 45.95% 1.99% 34.59%
WizardMonkey 138 55 83 39.86% 3.72% 31.69%
MonkeyBuccaneer 90 37 53 41.11% 2.42% 30.95%
MonkeyAce 56 23 33 41.07% 1.51% 28.19%
BombShooter 41 17 24 41.46% 1.10% 26.38%
Druid 35 11 24 31.43% 0.94% 16.05%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW neo_highway_towers AS 
WITH neo_highway AS
    (SELECT *
    FROM matches
    WHERE map = 'neo_highway')
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 neo_highway) * 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 neo_highway
                  UNION ALL
                  SELECT lt2           AS Tower,
                         playerLeftWin AS Win
                  FROM neo_highway
                  UNION ALL
                  SELECT lt3           AS Tower,
                         playerLeftWin AS Win
                  FROM neo_highway
                  UNION ALL
                  SELECT rt1               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM neo_highway
                  UNION ALL
                  SELECT rt2               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM neo_highway
                  UNION ALL
                  SELECT rt3               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM neo_highway)
            GROUP BY Tower))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;