oasis_loadouts (view)

54 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
BananaFarm, BombShooter, MonkeySub 297 192 105 64.65% 4.05% 59.21%
BananaFarm, BombShooter, SpikeFactory 257 162 95 63.04% 3.50% 57.13%
BananaFarm, BombShooter, DartlingGunner 56 38 18 67.86% 0.76% 55.63%
BananaFarm, BoomerangMonkey, SpikeFactory 39 27 12 69.23% 0.53% 54.75%
BananaFarm, EngineerMonkey, MonkeyAce 281 169 112 60.14% 3.83% 54.42%
BananaFarm, TackShooter, WizardMonkey 510 292 218 57.25% 6.95% 52.96%
BananaFarm, DartlingGunner, IceMonkey 157 95 62 60.51% 2.14% 52.86%
DartMonkey, SniperMonkey, SpikeFactory 38 25 13 65.79% 0.52% 50.71%
BananaFarm, Druid, MonkeySub 368 204 164 55.43% 5.01% 50.36%
BananaFarm, DartlingGunner, NinjaMonkey 61 38 23 62.30% 0.83% 50.13%
BananaFarm, DartMonkey, SpikeFactory 69 42 27 60.87% 0.94% 49.35%
BananaFarm, BombShooter, WizardMonkey 97 56 41 57.73% 1.32% 47.90%
BananaFarm, EngineerMonkey, SuperMonkey 170 92 78 54.12% 2.32% 46.63%
BananaFarm, BombShooter, MortarMonkey 37 23 14 62.16% 0.50% 46.53%
BananaFarm, HeliPilot, IceMonkey 64 37 27 57.81% 0.87% 45.71%
Alchemist, MonkeyBuccaneer, SpikeFactory 27 17 10 62.96% 0.37% 44.75%
BananaFarm, BoomerangMonkey, SniperMonkey 27 17 10 62.96% 0.37% 44.75%
HeliPilot, IceMonkey, MonkeyVillage 103 56 47 54.37% 1.40% 44.75%
BananaFarm, NinjaMonkey, WizardMonkey 89 49 40 55.06% 1.21% 44.72%
BananaFarm, IceMonkey, NinjaMonkey 78 43 35 55.13% 1.06% 44.09%
DartMonkey, MonkeyVillage, SuperMonkey 39 23 16 58.97% 0.53% 43.54%
BananaFarm, SniperMonkey, SuperMonkey 43 25 18 58.14% 0.59% 43.39%
BananaFarm, BoomerangMonkey, NinjaMonkey 102 54 48 52.94% 1.39% 43.25%
BananaFarm, EngineerMonkey, SpikeFactory 33 19 14 57.58% 0.45% 40.71%
BananaFarm, EngineerMonkey, WizardMonkey 60 32 28 53.33% 0.82% 40.71%
EngineerMonkey, MonkeyVillage, SpikeFactory 34 19 15 55.88% 0.46% 39.19%
DartlingGunner, MonkeyVillage, SuperMonkey 179 83 96 46.37% 2.44% 39.06%
BananaFarm, BoomerangMonkey, WizardMonkey 60 31 29 51.67% 0.82% 39.02%
BananaFarm, GlueGunner, HeliPilot 30 17 13 56.67% 0.41% 38.93%
EngineerMonkey, MonkeyAce, MonkeyVillage 24 14 10 58.33% 0.33% 38.61%
DartlingGunner, IceMonkey, MonkeyVillage 42 22 20 52.38% 0.57% 37.28%
Alchemist, HeliPilot, NinjaMonkey 27 15 12 55.56% 0.37% 36.81%
BananaFarm, IceMonkey, MonkeySub 258 110 148 42.64% 3.51% 36.60%
IceMonkey, MonkeyVillage, NinjaMonkey 28 15 13 53.57% 0.38% 35.10%
BananaFarm, BoomerangMonkey, SuperMonkey 26 14 12 53.85% 0.35% 34.68%
DartlingGunner, Druid, SpikeFactory 24 13 11 54.17% 0.33% 34.23%
BananaFarm, SniperMonkey, WizardMonkey 83 37 46 44.58% 1.13% 33.88%
BananaFarm, BoomerangMonkey, MortarMonkey 46 22 24 47.83% 0.63% 33.39%
Druid, MonkeySub, SpikeFactory 39 19 20 48.72% 0.53% 33.03%
Alchemist, MonkeyVillage, NinjaMonkey 23 12 11 52.17% 0.31% 31.76%
Druid, IceMonkey, MonkeyVillage 21 11 10 52.38% 0.29% 31.02%
Alchemist, BananaFarm, NinjaMonkey 97 37 60 38.14% 1.32% 28.48%
EngineerMonkey, TackShooter, WizardMonkey 20 10 10 50.00% 0.27% 28.09%
BananaFarm, SniperMonkey, TackShooter 42 18 24 42.86% 0.57% 27.89%
Alchemist, GlueGunner, NinjaMonkey 34 15 19 44.12% 0.46% 27.43%
GlueGunner, MonkeyVillage, TackShooter 118 42 76 35.59% 1.61% 26.95%
BoomerangMonkey, MonkeyVillage, SpikeFactory 21 10 11 47.62% 0.29% 26.26%
BananaFarm, BoomerangMonkey, EngineerMonkey 30 13 17 43.33% 0.41% 25.60%
BananaFarm, DartlingGunner, SuperMonkey 37 15 22 40.54% 0.50% 24.72%
SniperMonkey, TackShooter, WizardMonkey 27 11 16 40.74% 0.37% 22.21%

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;