ports_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Winrate_LowerBound_95CI

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Alchemist 680 425 255 62.50% 12.71% 58.86%
MortarMonkey 222 143 79 64.41% 4.15% 58.12%
MonkeyAce 1048 622 426 59.35% 19.58% 56.38%
MonkeySub 733 393 340 53.62% 13.70% 50.01%
BananaFarm 778 406 372 52.19% 14.54% 48.67%
DartMonkey 130 59 71 45.38% 2.43% 36.83%
SpikeFactory 152 64 88 42.11% 2.84% 34.26%
TackShooter 122 49 73 40.16% 2.28% 31.46%
BoomerangMonkey 105 42 63 40.00% 1.96% 30.63%
SniperMonkey 199 73 126 36.68% 3.72% 29.99%
EngineerMonkey 87 35 52 40.23% 1.63% 29.93%
HeliPilot 164 61 103 37.20% 3.06% 29.80%
WizardMonkey 167 62 105 37.13% 3.12% 29.80%
MonkeyBuccaneer 201 70 131 34.83% 3.76% 28.24%
NinjaMonkey 98 33 65 33.67% 1.83% 24.32%
DartlingGunner 44 17 27 38.64% 0.82% 24.25%
GlueGunner 103 33 70 32.04% 1.92% 23.03%
IceMonkey 71 23 48 32.39% 1.33% 21.51%
SuperMonkey 82 22 60 26.83% 1.53% 17.24%
BombShooter 52 15 37 28.85% 0.97% 16.53%
Druid 58 15 43 25.86% 1.08% 14.59%
MonkeyVillage 56 14 42 25.00% 1.05% 13.66%

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;