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 6070 3614 2456 59.54% 12.73% 58.30%
MortarMonkey 1832 1092 740 59.61% 3.84% 57.36%
MonkeyAce 9263 5376 3887 58.04% 19.43% 57.03%
MonkeySub 6831 3754 3077 54.96% 14.33% 53.78%
BananaFarm 7064 3637 3427 51.49% 14.81% 50.32%
DartMonkey 1294 590 704 45.60% 2.71% 42.88%
HeliPilot 1449 653 796 45.07% 3.04% 42.50%
Druid 627 282 345 44.98% 1.31% 41.08%
SniperMonkey 1982 799 1183 40.31% 4.16% 38.15%
SpikeFactory 1392 562 830 40.37% 2.92% 37.80%
EngineerMonkey 496 200 296 40.32% 1.04% 36.01%
WizardMonkey 1585 593 992 37.41% 3.32% 35.03%
MonkeyBuccaneer 1848 669 1179 36.20% 3.88% 34.01%
NinjaMonkey 763 285 478 37.35% 1.60% 33.92%
TackShooter 1030 366 664 35.53% 2.16% 32.61%
BombShooter 479 169 310 35.28% 1.00% 31.00%
GlueGunner 917 310 607 33.81% 1.92% 30.74%
SuperMonkey 567 191 376 33.69% 1.19% 29.80%
BoomerangMonkey 693 225 468 32.47% 1.45% 28.98%
IceMonkey 550 179 371 32.55% 1.15% 28.63%
DartlingGunner 368 120 248 32.61% 0.77% 27.82%
MonkeyVillage 582 175 407 30.07% 1.22% 26.34%

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;