oasis_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
BombShooter 909 557 352 61.28% 4.37% 58.11%
BananaFarm 4348 2344 2004 53.91% 20.90% 52.43%
MonkeySub 1982 1057 925 53.33% 9.53% 51.13%
MonkeyAce 389 209 180 53.73% 1.87% 48.77%
SpikeFactory 1104 565 539 51.18% 5.31% 48.23%
MortarMonkey 140 79 61 56.43% 0.67% 48.21%
DartlingGunner 745 383 362 51.41% 3.58% 47.82%
EngineerMonkey 538 279 259 51.86% 2.59% 47.64%
IceMonkey 1662 821 841 49.40% 7.99% 46.99%
Druid 635 319 316 50.24% 3.05% 46.35%
DartMonkey 347 177 170 51.01% 1.67% 45.75%
WizardMonkey 1373 664 709 48.36% 6.60% 45.72%
BoomerangMonkey 680 323 357 47.50% 3.27% 43.75%
SuperMonkey 619 285 334 46.04% 2.98% 42.12%
HeliPilot 404 188 216 46.53% 1.94% 41.67%
NinjaMonkey 1031 458 573 44.42% 4.96% 41.39%
MonkeyVillage 918 408 510 44.44% 4.41% 41.23%
TackShooter 908 402 506 44.27% 4.36% 41.04%
GlueGunner 499 223 276 44.69% 2.40% 40.33%
SniperMonkey 881 378 503 42.91% 4.24% 39.64%
Alchemist 450 193 257 42.89% 2.16% 38.32%
MonkeyBuccaneer 240 89 151 37.08% 1.15% 30.97%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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