off_tide_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MortarMonkey 431 247 184 57.31% 2.47% 52.64%
BananaFarm 3683 1963 1720 53.30% 21.14% 51.69%
DartlingGunner 986 527 459 53.45% 5.66% 50.33%
MonkeyAce 273 152 121 55.68% 1.57% 49.78%
TackShooter 1680 869 811 51.73% 9.64% 49.34%
IceMonkey 1039 543 496 52.26% 5.96% 49.22%
BoomerangMonkey 1082 562 520 51.94% 6.21% 48.96%
EngineerMonkey 425 228 197 53.65% 2.44% 48.91%
WizardMonkey 1644 824 820 50.12% 9.44% 47.70%
NinjaMonkey 1006 495 511 49.20% 5.77% 46.12%
BombShooter 460 230 230 50.00% 2.64% 45.43%
GlueGunner 561 268 293 47.77% 3.22% 43.64%
SpikeFactory 806 378 428 46.90% 4.63% 43.45%
Alchemist 280 131 149 46.79% 1.61% 40.94%
DartMonkey 256 120 136 46.88% 1.47% 40.76%
MonkeyVillage 835 367 468 43.95% 4.79% 40.59%
HeliPilot 326 148 178 45.40% 1.87% 39.99%
SuperMonkey 425 186 239 43.76% 2.44% 39.05%
SniperMonkey 755 303 452 40.13% 4.33% 36.64%
MonkeySub 249 95 154 38.15% 1.43% 32.12%
Druid 168 57 111 33.93% 0.96% 26.77%
MonkeyBuccaneer 54 19 35 35.19% 0.31% 22.45%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW off_tide_towers AS 
WITH off_tide AS
    (SELECT *
    FROM matches
    WHERE map = 'off_tide')
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 off_tide) * 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 off_tide
                  UNION ALL
                  SELECT lt2           AS Tower,
                         playerLeftWin AS Win
                  FROM off_tide
                  UNION ALL
                  SELECT lt3           AS Tower,
                         playerLeftWin AS Win
                  FROM off_tide
                  UNION ALL
                  SELECT rt1               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM off_tide
                  UNION ALL
                  SELECT rt2               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM off_tide
                  UNION ALL
                  SELECT rt3               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM off_tide)
            GROUP BY Tower))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;