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 1757 986 771 56.12% 6.96% 53.80%
BananaFarm 5095 2779 2316 54.54% 20.19% 53.18%
MonkeySub 2376 1286 1090 54.12% 9.42% 52.12%
EngineerMonkey 712 388 324 54.49% 2.82% 50.84%
IceMonkey 802 425 377 52.99% 3.18% 49.54%
Druid 1470 761 709 51.77% 5.83% 49.21%
MonkeyAce 402 214 188 53.23% 1.59% 48.36%
WizardMonkey 1559 773 786 49.58% 6.18% 47.10%
BoomerangMonkey 812 398 414 49.01% 3.22% 45.58%
MortarMonkey 208 108 100 51.92% 0.82% 45.13%
SpikeFactory 1380 658 722 47.68% 5.47% 45.05%
DartMonkey 548 269 279 49.09% 2.17% 44.90%
SniperMonkey 857 400 457 46.67% 3.40% 43.33%
NinjaMonkey 1027 470 557 45.76% 4.07% 42.72%
TackShooter 1126 510 616 45.29% 4.46% 42.39%
Alchemist 592 269 323 45.44% 2.35% 41.43%
MonkeyVillage 1258 543 715 43.16% 4.99% 40.43%
DartlingGunner 740 321 419 43.38% 2.93% 39.81%
HeliPilot 496 219 277 44.15% 1.97% 39.78%
SuperMonkey 833 348 485 41.78% 3.30% 38.43%
GlueGunner 824 342 482 41.50% 3.27% 38.14%
MonkeyBuccaneer 356 148 208 41.57% 1.41% 36.45%

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;