oasis_loadouts (view)

43 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
BananaFarm, BoomerangMonkey, EngineerMonkey 89 64 25 71.91% 1.14% 62.57%
BananaFarm, DartMonkey, SpikeFactory 46 34 12 73.91% 0.59% 61.22%
BananaFarm, EngineerMonkey, MonkeyAce 162 105 57 64.81% 2.08% 57.46%
BananaFarm, BombShooter, MonkeySub 464 278 186 59.91% 5.97% 55.45%
BananaFarm, BombShooter, WizardMonkey 94 61 33 64.89% 1.21% 55.24%
BananaFarm, BombShooter, SpikeFactory 331 190 141 57.40% 4.26% 52.07%
BananaFarm, DartlingGunner, IceMonkey 152 90 62 59.21% 1.95% 51.40%
BananaFarm, BombShooter, MortarMonkey 38 25 13 65.79% 0.49% 50.71%
BananaFarm, Druid, MonkeySub 675 367 308 54.37% 8.68% 50.61%
BananaFarm, TackShooter, WizardMonkey 430 237 193 55.12% 5.53% 50.42%
BananaFarm, IceMonkey, WizardMonkey 39 25 14 64.10% 0.50% 49.05%
BananaFarm, BombShooter, DartlingGunner 41 26 15 63.41% 0.53% 48.67%
BananaFarm, IceMonkey, MonkeySub 1000 516 484 51.60% 12.86% 48.50%
BananaFarm, NinjaMonkey, WizardMonkey 119 68 51 57.14% 1.53% 48.25%
DartlingGunner, MonkeyVillage, SuperMonkey 77 45 32 58.44% 0.99% 47.43%
IceMonkey, MonkeyVillage, NinjaMonkey 30 18 12 60.00% 0.39% 42.47%
Alchemist, BananaFarm, NinjaMonkey 127 64 63 50.39% 1.63% 41.70%
BananaFarm, MonkeySub, TackShooter 76 40 36 52.63% 0.98% 41.41%
BombShooter, MonkeyVillage, SpikeFactory 53 29 24 54.72% 0.68% 41.32%
SniperMonkey, TackShooter, WizardMonkey 33 19 14 57.58% 0.42% 40.71%
BananaFarm, BoomerangMonkey, MortarMonkey 25 14 11 56.00% 0.32% 36.54%
DartMonkey, MonkeySub, NinjaMonkey 25 14 11 56.00% 0.32% 36.54%
DartlingGunner, Druid, MonkeyVillage 24 13 11 54.17% 0.31% 34.23%
DartlingGunner, SpikeFactory, SuperMonkey 36 18 18 50.00% 0.46% 33.67%
BananaFarm, BoomerangMonkey, NinjaMonkey 82 36 46 43.90% 1.05% 33.16%
GlueGunner, HeliPilot, MonkeyVillage 39 19 20 48.72% 0.50% 33.03%
BananaFarm, BoomerangMonkey, MonkeySub 46 21 25 45.65% 0.59% 31.26%
DartlingGunner, IceMonkey, MonkeyVillage 41 19 22 46.34% 0.53% 31.08%
BananaFarm, BoomerangMonkey, WizardMonkey 26 13 13 50.00% 0.33% 30.78%
BananaFarm, BoomerangMonkey, SpikeFactory 85 35 50 41.18% 1.09% 30.71%
DartMonkey, GlueGunner, MonkeyVillage 42 19 23 45.24% 0.54% 30.19%
Alchemist, HeliPilot, NinjaMonkey 36 16 20 44.44% 0.46% 28.21%
BananaFarm, SniperMonkey, WizardMonkey 56 23 33 41.07% 0.72% 28.19%
BombShooter, MonkeyVillage, TackShooter 20 10 10 50.00% 0.26% 28.09%
EngineerMonkey, TackShooter, WizardMonkey 39 17 22 43.59% 0.50% 28.03%
BananaFarm, BoomerangMonkey, GlueGunner 21 10 11 47.62% 0.27% 26.26%
BananaFarm, HeliPilot, MonkeySub 21 10 11 47.62% 0.27% 26.26%
GlueGunner, MonkeyVillage, TackShooter 85 29 56 34.12% 1.09% 24.04%
BananaFarm, SniperMonkey, TackShooter 32 13 19 40.63% 0.41% 23.61%
EngineerMonkey, MonkeyVillage, SpikeFactory 41 15 26 36.59% 0.53% 21.84%
Alchemist, MonkeyVillage, NinjaMonkey 29 11 18 37.93% 0.37% 20.27%
Alchemist, NinjaMonkey, SniperMonkey 44 14 30 31.82% 0.57% 18.06%
BananaFarm, DartlingGunner, SuperMonkey 35 11 24 31.43% 0.45% 16.05%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW oasis_loadouts AS 
WITH oasis AS
    (SELECT *
    FROM matches
    WHERE map = 'oasis')
SELECT Loadout,
       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 Loadout,
             Games,
             Wins,
             Losses,
             CAST(Wins AS REAL) / Games AS WR,
             CAST(Games AS REAL) / (
                 (SELECT COUNT(*)
                  FROM oasis) * 2)    AS PR
      FROM (SELECT Loadout,
                   SUM(Win) + SUM(NOT Win) AS Games,
                   SUM(Win)                AS Wins,
                   SUM(NOT Win)            AS Losses
            FROM (SELECT printf('%s, %s, %s', lt1, lt2, lt3) AS Loadout,
                         playerLeftWin                       AS Win
                  FROM oasis
                  UNION ALL
                  SELECT printf('%s, %s, %s', rt1, rt2, rt3) AS Loadout,
                         NOT playerLeftWin                   AS Win
                  FROM oasis)
            GROUP BY Loadout)
      WHERE Wins >= 10
        AND Losses >= 10)
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(WinRate_LowerBound_95CI) = 6
ORDER BY WinRate_LowerBound_95CI DESC;