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
DartMonkey 4337 2464 1873 56.81% 11.00% 55.34%
SpikeFactory 6584 3601 2983 54.69% 16.69% 53.49%
BananaFarm 7275 3973 3302 54.61% 18.44% 53.47%
MortarMonkey 935 524 411 56.04% 2.37% 52.86%
BoomerangMonkey 1479 780 699 52.74% 3.75% 50.19%
GlueGunner 2242 1150 1092 51.29% 5.68% 49.22%
DartlingGunner 3557 1703 1854 47.88% 9.02% 46.24%
SuperMonkey 952 460 492 48.32% 2.41% 45.14%
Alchemist 1588 721 867 45.40% 4.03% 42.95%
NinjaMonkey 1190 530 660 44.54% 3.02% 41.71%
MonkeyVillage 836 374 462 44.74% 2.12% 41.37%
MonkeySub 1002 444 558 44.31% 2.54% 41.24%
EngineerMonkey 519 233 286 44.89% 1.32% 40.61%
HeliPilot 902 391 511 43.35% 2.29% 40.11%
SniperMonkey 2192 903 1289 41.20% 5.56% 39.13%
IceMonkey 546 231 315 42.31% 1.38% 38.16%
MonkeyAce 374 158 216 42.25% 0.95% 37.24%
WizardMonkey 1503 594 909 39.52% 3.81% 37.05%
BombShooter 288 109 179 37.85% 0.73% 32.25%
Druid 318 110 208 34.59% 0.81% 29.36%
MonkeyBuccaneer 501 164 337 32.73% 1.27% 28.63%
TackShooter 324 105 219 32.41% 0.82% 27.31%

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;