ports_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Alchemist 847 492 355 58.09% 13.61% 54.76%
MonkeyAce 1174 670 504 57.07% 18.87% 54.24%
MonkeySub 694 396 298 57.06% 11.15% 53.38%
MortarMonkey 195 115 80 58.97% 3.13% 52.07%
BananaFarm 814 441 373 54.18% 13.08% 50.75%
DartMonkey 281 138 143 49.11% 4.52% 43.27%
HeliPilot 140 68 72 48.57% 2.25% 40.29%
MonkeyBuccaneer 336 139 197 41.37% 5.40% 36.10%
SniperMonkey 279 116 163 41.58% 4.48% 35.79%
EngineerMonkey 84 36 48 42.86% 1.35% 32.27%
SpikeFactory 235 88 147 37.45% 3.78% 31.26%
SuperMonkey 97 39 58 40.21% 1.56% 30.45%
BoomerangMonkey 95 38 57 40.00% 1.53% 30.15%
IceMonkey 81 33 48 40.74% 1.30% 30.04%
Druid 71 29 42 40.85% 1.14% 29.41%
WizardMonkey 183 64 119 34.97% 2.94% 28.06%
BombShooter 71 27 44 38.03% 1.14% 26.74%
GlueGunner 196 65 131 33.16% 3.15% 26.57%
NinjaMonkey 100 34 66 34.00% 1.61% 24.72%
TackShooter 108 36 72 33.33% 1.74% 24.44%
MonkeyVillage 94 31 63 32.98% 1.51% 23.47%
DartlingGunner 47 16 31 34.04% 0.76% 20.50%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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