oasis_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
BombShooter 1290 736 554 57.05% 6.24% 54.35%
IceMonkey 880 497 383 56.48% 4.26% 53.20%
BananaFarm 3520 1894 1626 53.81% 17.03% 52.16%
MonkeySub 1372 751 621 54.74% 6.64% 52.10%
Druid 941 491 450 52.18% 4.55% 48.99%
EngineerMonkey 475 252 223 53.05% 2.30% 48.56%
MortarMonkey 206 112 94 54.37% 1.00% 47.57%
DartMonkey 711 358 353 50.35% 3.44% 46.68%
DartlingGunner 885 433 452 48.93% 4.28% 45.63%
Alchemist 561 276 285 49.20% 2.71% 45.06%
MonkeyVillage 1214 574 640 47.28% 5.87% 44.47%
WizardMonkey 1210 572 638 47.27% 5.86% 44.46%
GlueGunner 916 433 483 47.27% 4.43% 44.04%
BoomerangMonkey 548 262 286 47.81% 2.65% 43.63%
TackShooter 729 344 385 47.19% 3.53% 43.56%
MonkeyAce 267 132 135 49.44% 1.29% 43.44%
NinjaMonkey 836 389 447 46.53% 4.05% 43.15%
SpikeFactory 1230 563 667 45.77% 5.95% 42.99%
HeliPilot 616 283 333 45.94% 2.98% 42.01%
SuperMonkey 983 433 550 44.05% 4.76% 40.95%
MonkeyBuccaneer 419 185 234 44.15% 2.03% 39.40%
SniperMonkey 855 362 493 42.34% 4.14% 39.03%

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;