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 551 332 219 60.25% 10.17% 56.17%
MonkeyAce 943 545 398 57.79% 17.40% 54.64%
MonkeySub 905 486 419 53.70% 16.70% 50.45%
MortarMonkey 214 121 93 56.54% 3.95% 49.90%
Druid 88 52 36 59.09% 1.62% 48.82%
BananaFarm 962 481 481 50.00% 17.76% 46.84%
HeliPilot 210 107 103 50.95% 3.88% 44.19%
DartMonkey 100 53 47 53.00% 1.85% 43.22%
SniperMonkey 271 116 155 42.80% 5.00% 36.91%
WizardMonkey 204 87 117 42.65% 3.77% 35.86%
TackShooter 141 56 85 39.72% 2.60% 31.64%
SpikeFactory 103 39 64 37.86% 1.90% 28.50%
NinjaMonkey 91 34 57 37.36% 1.68% 27.42%
BoomerangMonkey 86 31 55 36.05% 1.59% 25.90%
EngineerMonkey 48 18 30 37.50% 0.89% 23.80%
MonkeyBuccaneer 148 46 102 31.08% 2.73% 23.62%
GlueGunner 66 23 43 34.85% 1.22% 23.35%
SuperMonkey 53 18 35 33.96% 0.98% 21.21%
IceMonkey 96 28 68 29.17% 1.77% 20.07%
MonkeyVillage 56 15 41 26.79% 1.03% 15.19%
BombShooter 43 11 32 25.58% 0.79% 12.54%
DartlingGunner 39 10 29 25.64% 0.72% 11.94%

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;