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 1014 602 412 59.37% 4.60% 56.35%
BananaFarm 4347 2354 1993 54.15% 19.74% 52.67%
SpikeFactory 1147 620 527 54.05% 5.21% 51.17%
MonkeyAce 518 282 236 54.44% 2.35% 50.15%
EngineerMonkey 932 494 438 53.00% 4.23% 49.80%
DartlingGunner 930 482 448 51.83% 4.22% 48.62%
MonkeySub 1233 627 606 50.85% 5.60% 48.06%
WizardMonkey 1649 827 822 50.15% 7.49% 47.74%
BoomerangMonkey 753 374 379 49.67% 3.42% 46.10%
HeliPilot 535 268 267 50.09% 2.43% 45.86%
Druid 745 366 379 49.13% 3.38% 45.54%
IceMonkey 1064 516 548 48.50% 4.83% 45.49%
MortarMonkey 213 108 105 50.70% 0.97% 43.99%
TackShooter 1142 530 612 46.41% 5.19% 43.52%
SuperMonkey 932 430 502 46.14% 4.23% 42.94%
NinjaMonkey 1042 477 565 45.78% 4.73% 42.75%
DartMonkey 428 201 227 46.96% 1.94% 42.23%
MonkeyVillage 1114 497 617 44.61% 5.06% 41.69%
Alchemist 444 201 243 45.27% 2.02% 40.64%
SniperMonkey 923 377 546 40.85% 4.19% 37.67%
GlueGunner 556 231 325 41.55% 2.52% 37.45%
MonkeyBuccaneer 359 146 213 40.67% 1.63% 35.59%

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;