neo_highway_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
DartMonkey 864 502 362 58.10% 12.07% 54.81%
SpikeFactory 1135 636 499 56.04% 15.86% 53.15%
BananaFarm 1356 725 631 53.47% 18.94% 50.81%
MortarMonkey 138 81 57 58.70% 1.93% 50.48%
GlueGunner 231 125 106 54.11% 3.23% 47.69%
BoomerangMonkey 249 126 123 50.60% 3.48% 44.39%
SuperMonkey 195 100 95 51.28% 2.72% 44.27%
DartlingGunner 716 342 374 47.77% 10.00% 44.11%
Alchemist 255 126 129 49.41% 3.56% 43.28%
NinjaMonkey 299 136 163 45.48% 4.18% 39.84%
SniperMonkey 489 211 278 43.15% 6.83% 38.76%
MonkeyVillage 152 70 82 46.05% 2.12% 38.13%
WizardMonkey 348 136 212 39.08% 4.86% 33.95%
EngineerMonkey 103 43 60 41.75% 1.44% 32.22%
MonkeySub 143 57 86 39.86% 2.00% 31.84%
HeliPilot 153 57 96 37.25% 2.14% 29.59%
BombShooter 40 15 25 37.50% 0.56% 22.50%
MonkeyAce 46 16 30 34.78% 0.64% 21.02%
Druid 39 14 25 35.90% 0.54% 20.84%
MonkeyBuccaneer 67 20 47 29.85% 0.94% 18.89%
TackShooter 63 19 44 30.16% 0.88% 18.83%
IceMonkey 77 22 55 28.57% 1.08% 18.48%

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;