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 781 435 346 55.70% 11.81% 52.21%
SpikeFactory 1057 572 485 54.12% 15.99% 51.11%
BananaFarm 1378 740 638 53.70% 20.84% 51.07%
MortarMonkey 144 85 59 59.03% 2.18% 51.00%
DartlingGunner 572 299 273 52.27% 8.65% 48.18%
NinjaMonkey 238 129 109 54.20% 3.60% 47.87%
BoomerangMonkey 207 110 97 53.14% 3.13% 46.34%
GlueGunner 313 156 157 49.84% 4.73% 44.30%
MonkeyVillage 128 60 68 46.88% 1.94% 38.23%
Alchemist 194 87 107 44.85% 2.93% 37.85%
SuperMonkey 132 60 72 45.45% 2.00% 36.96%
SniperMonkey 386 157 229 40.67% 5.84% 35.77%
HeliPilot 155 65 90 41.94% 2.34% 34.17%
MonkeySub 214 87 127 40.65% 3.24% 34.07%
WizardMonkey 264 101 163 38.26% 3.99% 32.39%
EngineerMonkey 73 31 42 42.47% 1.10% 31.13%
IceMonkey 118 46 72 38.98% 1.78% 30.18%
BombShooter 47 18 29 38.30% 0.71% 24.40%
MonkeyAce 43 16 27 37.21% 0.65% 22.76%
Druid 50 18 32 36.00% 0.76% 22.70%
MonkeyBuccaneer 62 18 44 29.03% 0.94% 17.73%
TackShooter 56 16 40 28.57% 0.85% 16.74%

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;