ports_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MortarMonkey 226 139 87 61.50% 3.61% 55.16%
MonkeyAce 1180 678 502 57.46% 18.87% 54.64%
Alchemist 811 460 351 56.72% 12.97% 53.31%
MonkeySub 836 453 383 54.19% 13.37% 50.81%
BananaFarm 839 453 386 53.99% 13.42% 50.62%
EngineerMonkey 57 33 24 57.89% 0.91% 45.08%
NinjaMonkey 129 59 70 45.74% 2.06% 37.14%
HeliPilot 180 79 101 43.89% 2.88% 36.64%
SniperMonkey 247 104 143 42.11% 3.95% 35.95%
SuperMonkey 87 40 47 45.98% 1.39% 35.50%
TackShooter 157 67 90 42.68% 2.51% 34.94%
WizardMonkey 183 76 107 41.53% 2.93% 34.39%
IceMonkey 48 23 25 47.92% 0.77% 33.78%
DartMonkey 241 95 146 39.42% 3.85% 33.25%
MonkeyBuccaneer 322 121 201 37.58% 5.15% 32.29%
SpikeFactory 166 60 106 36.14% 2.66% 28.84%
BombShooter 68 27 41 39.71% 1.09% 28.08%
Druid 83 32 51 38.55% 1.33% 28.08%
MonkeyVillage 90 32 58 35.56% 1.44% 25.67%
GlueGunner 178 55 123 30.90% 2.85% 24.11%
BoomerangMonkey 74 24 50 32.43% 1.18% 21.77%
DartlingGunner 50 16 34 32.00% 0.80% 19.07%

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;