ports_towers (view)

21 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MortarMonkey 323 204 119 63.16% 4.89% 57.90%
MonkeyAce 1332 763 569 57.28% 20.16% 54.63%
Alchemist 707 411 296 58.13% 10.70% 54.50%
MonkeySub 1120 603 517 53.84% 16.95% 50.92%
BananaFarm 1222 628 594 51.39% 18.50% 48.59%
HeliPilot 170 87 83 51.18% 2.57% 43.66%
DartMonkey 122 59 63 48.36% 1.85% 39.49%
Druid 126 58 68 46.03% 1.91% 37.33%
SpikeFactory 153 65 88 42.48% 2.32% 34.65%
NinjaMonkey 98 39 59 39.80% 1.48% 30.10%
SniperMonkey 267 90 177 33.71% 4.04% 28.04%
WizardMonkey 214 72 142 33.64% 3.24% 27.31%
MonkeyBuccaneer 150 46 104 30.67% 2.27% 23.29%
TackShooter 142 43 99 30.28% 2.15% 22.72%
BombShooter 54 19 35 35.19% 0.82% 22.45%
GlueGunner 66 22 44 33.33% 1.00% 21.96%
EngineerMonkey 52 18 34 34.62% 0.79% 21.68%
IceMonkey 81 24 57 29.63% 1.23% 19.69%
MonkeyVillage 57 18 39 31.58% 0.86% 19.51%
DartlingGunner 38 11 27 28.95% 0.58% 14.53%
BoomerangMonkey 71 15 56 21.13% 1.07% 11.63%

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;