oasis_loadouts (view)

57 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
BananaFarm, DartMonkey, GlueGunner 146 101 45 69.18% 1.82% 61.69%
BananaFarm, EngineerMonkey, MonkeyAce 177 119 58 67.23% 2.20% 60.32%
BananaFarm, BombShooter, MonkeySub 432 264 168 61.11% 5.37% 56.51%
BananaFarm, DartMonkey, MortarMonkey 124 79 45 63.71% 1.54% 55.25%
IceMonkey, MonkeyVillage, TackShooter 42 29 13 69.05% 0.52% 55.07%
DartlingGunner, MonkeyVillage, SuperMonkey 171 105 66 61.40% 2.13% 54.11%
BananaFarm, BoomerangMonkey, SuperMonkey 41 28 13 68.29% 0.51% 54.05%
EngineerMonkey, TackShooter, WizardMonkey 35 24 11 68.57% 0.44% 53.19%
BananaFarm, BombShooter, SpikeFactory 382 220 162 57.59% 4.75% 52.64%
BananaFarm, IceMonkey, NinjaMonkey 37 24 13 64.86% 0.46% 49.48%
BananaFarm, DartlingGunner, IceMonkey 180 102 78 56.67% 2.24% 49.43%
BananaFarm, BombShooter, WizardMonkey 182 103 79 56.59% 2.26% 49.39%
BananaFarm, Druid, MonkeySub 389 205 184 52.70% 4.84% 47.74%
BananaFarm, BoomerangMonkey, WizardMonkey 31 20 11 64.52% 0.39% 47.67%
DartlingGunner, IceMonkey, MonkeyVillage 73 43 30 58.90% 0.91% 47.62%
BananaFarm, DartMonkey, SpikeFactory 45 27 18 60.00% 0.56% 45.69%
BananaFarm, TackShooter, WizardMonkey 145 78 67 53.79% 1.80% 45.68%
BombShooter, MonkeySub, SpikeFactory 46 27 19 58.70% 0.57% 44.47%
DartMonkey, GlueGunner, MonkeyVillage 153 80 73 52.29% 1.90% 44.37%
Alchemist, BananaFarm, NinjaMonkey 131 69 62 52.67% 1.63% 44.12%
BananaFarm, BoomerangMonkey, SpikeFactory 57 31 26 54.39% 0.71% 41.46%
MonkeyVillage, SniperMonkey, TackShooter 51 28 23 54.90% 0.63% 41.25%
BananaFarm, EngineerMonkey, SuperMonkey 64 34 30 53.13% 0.80% 40.90%
BananaFarm, BombShooter, MortarMonkey 37 21 16 56.76% 0.46% 40.79%
Alchemist, GlueGunner, NinjaMonkey 80 41 39 51.25% 0.99% 40.30%
HeliPilot, IceMonkey, SuperMonkey 64 33 31 51.56% 0.80% 39.32%
Alchemist, NinjaMonkey, SniperMonkey 47 25 22 53.19% 0.58% 38.93%
DartMonkey, IceMonkey, MonkeyVillage 28 16 12 57.14% 0.35% 38.81%
BananaFarm, EngineerMonkey, SpikeFactory 24 14 10 58.33% 0.30% 38.61%
GlueGunner, MonkeyVillage, NinjaMonkey 74 36 38 48.65% 0.92% 37.26%
GlueGunner, HeliPilot, MonkeyVillage 174 74 100 42.53% 2.16% 35.18%
Alchemist, NinjaMonkey, SpikeFactory 35 18 17 51.43% 0.44% 34.87%
MonkeyBuccaneer, SniperMonkey, WizardMonkey 33 17 16 51.52% 0.41% 34.46%
BananaFarm, DartMonkey, WizardMonkey 41 20 21 48.78% 0.51% 33.48%
Alchemist, HeliPilot, NinjaMonkey 61 28 33 45.90% 0.76% 33.40%
BananaFarm, DartlingGunner, SuperMonkey 92 39 53 42.39% 1.14% 32.29%
SpikeFactory, TackShooter, WizardMonkey 23 12 11 52.17% 0.29% 31.76%
BananaFarm, BombShooter, DartlingGunner 28 14 14 50.00% 0.35% 31.48%
BombShooter, SpikeFactory, WizardMonkey 33 16 17 48.48% 0.41% 31.43%
Alchemist, MonkeyBuccaneer, SpikeFactory 70 30 40 42.86% 0.87% 31.26%
Druid, MonkeySub, SpikeFactory 49 22 27 44.90% 0.61% 30.97%
BananaFarm, BoomerangMonkey, NinjaMonkey 29 14 15 48.28% 0.36% 30.09%
SniperMonkey, SuperMonkey, WizardMonkey 24 12 12 50.00% 0.30% 30.00%
BananaFarm, BombShooter, SuperMonkey 22 11 11 50.00% 0.27% 29.11%
BombShooter, MonkeyVillage, SuperMonkey 22 11 11 50.00% 0.27% 29.11%
GlueGunner, MonkeyVillage, TackShooter 88 34 54 38.64% 1.09% 28.46%
EngineerMonkey, IceMonkey, SniperMonkey 20 10 10 50.00% 0.25% 28.09%
BananaFarm, SniperMonkey, WizardMonkey 61 24 37 39.34% 0.76% 27.08%
BananaFarm, SniperMonkey, TackShooter 42 17 25 40.48% 0.52% 25.63%
Alchemist, Druid, MonkeyVillage 49 19 30 38.78% 0.61% 25.13%

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;