sun_palace_loadouts (view)

48 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, EngineerMonkey, MonkeyAce 1150 741 409 64.43% 15.87% 61.67%
BananaFarm, BoomerangMonkey, MonkeyAce 34 24 10 70.59% 0.47% 55.27%
BananaFarm, BoomerangMonkey, MortarMonkey 40 27 13 67.50% 0.55% 52.98%
BananaFarm, IceMonkey, WizardMonkey 53 34 19 64.15% 0.73% 51.24%
BananaFarm, BoomerangMonkey, EngineerMonkey 146 84 62 57.53% 2.01% 49.52%
GlueGunner, HeliPilot, MonkeyVillage 416 222 194 53.37% 5.74% 48.57%
BananaFarm, DartMonkey, IceMonkey 43 27 16 62.79% 0.59% 48.34%
BananaFarm, BombShooter, WizardMonkey 117 67 50 57.26% 1.61% 48.30%
BananaFarm, BombShooter, MonkeySub 76 45 31 59.21% 1.05% 48.16%
BananaFarm, TackShooter, WizardMonkey 364 190 174 52.20% 5.02% 47.07%
Alchemist, IceMonkey, NinjaMonkey 32 20 12 62.50% 0.44% 45.73%
BananaFarm, EngineerMonkey, SuperMonkey 61 35 26 57.38% 0.84% 44.97%
GlueGunner, MonkeyVillage, TackShooter 256 130 126 50.78% 3.53% 44.66%
BananaFarm, BoomerangMonkey, NinjaMonkey 190 98 92 51.58% 2.62% 44.47%
BananaFarm, BoomerangMonkey, SpikeFactory 147 76 71 51.70% 2.03% 43.62%
HeliPilot, IceMonkey, SuperMonkey 59 33 26 55.93% 0.81% 43.26%
BananaFarm, Druid, MonkeySub 154 78 76 50.65% 2.12% 42.75%
DartMonkey, GlueGunner, MonkeyVillage 85 42 43 49.41% 1.17% 38.78%
BananaFarm, IceMonkey, SuperMonkey 43 23 20 53.49% 0.59% 38.58%
IceMonkey, MonkeyVillage, TackShooter 35 19 16 54.29% 0.48% 37.78%
BananaFarm, BombShooter, SniperMonkey 34 18 16 52.94% 0.47% 36.16%
BananaFarm, DartMonkey, MortarMonkey 41 21 20 51.22% 0.57% 35.92%
BananaFarm, BoomerangMonkey, SuperMonkey 40 20 20 50.00% 0.55% 34.50%
BananaFarm, BombShooter, SpikeFactory 43 21 22 48.84% 0.59% 33.90%
BombShooter, MonkeyBuccaneer, WizardMonkey 22 12 10 54.55% 0.30% 33.74%
Druid, SniperMonkey, SuperMonkey 22 12 10 54.55% 0.30% 33.74%
GlueGunner, MonkeyVillage, NinjaMonkey 53 25 28 47.17% 0.73% 33.73%
DartlingGunner, MonkeyVillage, SuperMonkey 41 20 21 48.78% 0.57% 33.48%
BananaFarm, MortarMonkey, TackShooter 23 12 11 52.17% 0.32% 31.76%
SniperMonkey, SuperMonkey, TackShooter 21 11 10 52.38% 0.29% 31.02%
Alchemist, HeliPilot, NinjaMonkey 36 17 19 47.22% 0.50% 30.91%
BananaFarm, BombShooter, MortarMonkey 31 15 16 48.39% 0.43% 30.79%
SniperMonkey, TackShooter, WizardMonkey 52 23 29 44.23% 0.72% 30.73%
SniperMonkey, SuperMonkey, WizardMonkey 25 12 13 48.00% 0.34% 28.42%
SniperMonkey, SpikeFactory, WizardMonkey 20 10 10 50.00% 0.28% 28.09%
BananaFarm, IceMonkey, NinjaMonkey 28 13 15 46.43% 0.39% 27.96%
BananaFarm, NinjaMonkey, TackShooter 30 13 17 43.33% 0.41% 25.60%
Alchemist, BananaFarm, NinjaMonkey 76 27 49 35.53% 1.05% 24.77%
BananaFarm, BoomerangMonkey, SniperMonkey 22 10 12 45.45% 0.30% 24.65%
BananaFarm, DartMonkey, SpikeFactory 22 10 12 45.45% 0.30% 24.65%
IceMonkey, MonkeyVillage, NinjaMonkey 50 19 31 38.00% 0.69% 24.55%
BananaFarm, DartMonkey, GlueGunner 61 22 39 36.07% 0.84% 24.02%
BananaFarm, EngineerMonkey, SpikeFactory 39 15 24 38.46% 0.54% 23.19%
BananaFarm, SniperMonkey, WizardMonkey 56 20 36 35.71% 0.77% 23.16%
BananaFarm, DartMonkey, WizardMonkey 27 11 16 40.74% 0.37% 22.21%
BananaFarm, GlueGunner, MonkeySub 35 13 22 37.14% 0.48% 21.13%
BananaFarm, NinjaMonkey, WizardMonkey 44 15 29 34.09% 0.61% 20.08%
NinjaMonkey, TackShooter, WizardMonkey 37 13 24 35.14% 0.51% 19.75%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW sun_palace_loadouts AS 
WITH sun_palace AS
    (SELECT *
    FROM matches
    WHERE map = 'sun_palace')
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 sun_palace) * 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 sun_palace
                  UNION ALL
                  SELECT printf('%s, %s, %s', rt1, rt2, rt3) AS Loadout,
                         NOT playerLeftWin                   AS Win
                  FROM sun_palace)
            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;