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 10284 5916 4368 57.53% 5.71% 56.57%
BananaFarm 32159 17451 14708 54.26% 17.87% 53.72%
MortarMonkey 1896 1057 839 55.75% 1.05% 53.51%
MonkeySub 12804 6839 5965 53.41% 7.11% 52.55%
EngineerMonkey 4537 2419 2118 53.32% 2.52% 51.87%
IceMonkey 8082 4235 3847 52.40% 4.49% 51.31%
MonkeyAce 2636 1402 1234 53.19% 1.46% 51.28%
DartMonkey 6125 3193 2932 52.13% 3.40% 50.88%
Druid 7331 3670 3661 50.06% 4.07% 48.92%
SpikeFactory 11159 5512 5647 49.40% 6.20% 48.47%
BoomerangMonkey 5459 2701 2758 49.48% 3.03% 48.15%
WizardMonkey 11292 5529 5763 48.96% 6.27% 48.04%
DartlingGunner 6496 3176 3320 48.89% 3.61% 47.68%
MonkeyVillage 9750 4511 5239 46.27% 5.42% 45.28%
GlueGunner 7476 3434 4042 45.93% 4.15% 44.80%
TackShooter 7377 3381 3996 45.83% 4.10% 44.69%
Alchemist 5014 2284 2730 45.55% 2.79% 44.17%
NinjaMonkey 8119 3672 4447 45.23% 4.51% 44.14%
HeliPilot 3797 1735 2062 45.69% 2.11% 44.11%
SuperMonkey 7033 3129 3904 44.49% 3.91% 43.33%
SniperMonkey 7857 3405 4452 43.34% 4.37% 42.24%
MonkeyBuccaneer 3317 1349 1968 40.67% 1.84% 39.00%

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;