ports_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Alchemist 705 440 265 62.41% 12.29% 58.84%
Druid 74 51 23 68.92% 1.29% 58.37%
MonkeyAce 1055 622 433 58.96% 18.39% 55.99%
MonkeySub 868 483 385 55.65% 15.13% 52.34%
MortarMonkey 239 138 101 57.74% 4.17% 51.48%
BananaFarm 889 433 456 48.71% 15.50% 45.42%
DartMonkey 89 43 46 48.31% 1.55% 37.93%
WizardMonkey 266 108 158 40.60% 4.64% 34.70%
SniperMonkey 242 96 146 39.67% 4.22% 33.51%
HeliPilot 264 102 162 38.64% 4.60% 32.76%
NinjaMonkey 78 34 44 43.59% 1.36% 32.58%
MonkeyBuccaneer 177 68 109 38.42% 3.09% 31.25%
TackShooter 136 46 90 33.82% 2.37% 25.87%
BoomerangMonkey 76 27 49 35.53% 1.32% 24.77%
DartlingGunner 57 21 36 36.84% 0.99% 24.32%
EngineerMonkey 68 24 44 35.29% 1.19% 23.94%
SpikeFactory 107 35 72 32.71% 1.87% 23.82%
GlueGunner 68 22 46 32.35% 1.19% 21.23%
BombShooter 44 15 29 34.09% 0.77% 20.08%
MonkeyVillage 90 26 64 28.89% 1.57% 19.52%
IceMonkey 82 19 63 23.17% 1.43% 14.04%
SuperMonkey 62 15 47 24.19% 1.08% 13.53%

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;