oasis_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Pickrate

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
BananaFarm 1183 645 538 54.52% 21.27% 51.68%
BombShooter 366 204 162 55.74% 6.58% 50.65%
MonkeyAce 97 58 39 59.79% 1.74% 50.04%
IceMonkey 265 148 117 55.85% 4.76% 49.87%
EngineerMonkey 181 101 80 55.80% 3.25% 48.57%
WizardMonkey 359 188 171 52.37% 6.45% 47.20%
MonkeySub 371 193 178 52.02% 6.67% 46.94%
MortarMonkey 50 30 20 60.00% 0.90% 46.42%
DartlingGunner 300 148 152 49.33% 5.39% 43.68%
DartMonkey 115 60 55 52.17% 2.07% 43.04%
SpikeFactory 351 168 183 47.86% 6.31% 42.64%
TackShooter 236 115 121 48.73% 4.24% 42.35%
NinjaMonkey 299 142 157 47.49% 5.38% 41.83%
Druid 173 84 89 48.55% 3.11% 41.11%
HeliPilot 104 51 53 49.04% 1.87% 39.43%
Alchemist 151 66 85 43.71% 2.71% 35.80%
SuperMonkey 210 88 122 41.90% 3.78% 35.23%
GlueGunner 139 59 80 42.45% 2.50% 34.23%
MonkeyVillage 236 93 143 39.41% 4.24% 33.17%
BoomerangMonkey 152 61 91 40.13% 2.73% 32.34%
SniperMonkey 156 58 98 37.18% 2.80% 29.60%
MonkeyBuccaneer 68 21 47 30.88% 1.22% 19.90%

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;