garden_loadouts (view)

27 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Winrate, Pickrate

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
BananaFarm, BoomerangMonkey, MortarMonkey 58 45 13 77.59% 1.57% 66.85%
BananaFarm, DartlingGunner, NinjaMonkey 60 44 16 73.33% 1.62% 62.14%
DartMonkey, NinjaMonkey, SniperMonkey 138 93 45 67.39% 3.74% 59.57%
BananaFarm, DartMonkey, MonkeySub 106 70 36 66.04% 2.87% 57.02%
BananaFarm, DartMonkey, MortarMonkey 170 109 61 64.12% 4.60% 56.91%
DartMonkey, GlueGunner, MonkeyVillage 267 152 115 56.93% 7.23% 50.99%
BananaFarm, Druid, MonkeySub 179 100 79 55.87% 4.85% 48.59%
BananaFarm, DartMonkey, SniperMonkey 70 41 29 58.57% 1.89% 47.03%
BananaFarm, BombShooter, WizardMonkey 34 21 13 61.76% 0.92% 45.43%
BananaFarm, EngineerMonkey, MonkeyAce 80 45 35 56.25% 2.17% 45.38%
DartMonkey, GlueGunner, MonkeySub 26 16 10 61.54% 0.70% 42.84%
DartMonkey, MonkeyVillage, SniperMonkey 28 17 11 60.71% 0.76% 42.62%
Alchemist, MonkeyBuccaneer, SpikeFactory 42 24 18 57.14% 1.14% 42.18%
BananaFarm, BoomerangMonkey, SpikeFactory 31 18 13 58.06% 0.84% 40.69%
BananaFarm, DartMonkey, SpikeFactory 92 46 46 50.00% 2.49% 39.78%
BananaFarm, DartMonkey, WizardMonkey 40 22 18 55.00% 1.08% 39.58%
BananaFarm, DartlingGunner, IceMonkey 44 23 21 52.27% 1.19% 37.51%
BananaFarm, DartMonkey, GlueGunner 143 63 80 44.06% 3.87% 35.92%
BananaFarm, BoomerangMonkey, NinjaMonkey 39 20 19 51.28% 1.06% 35.59%
DartlingGunner, MonkeyVillage, SuperMonkey 70 33 37 47.14% 1.89% 35.45%
BananaFarm, DartMonkey, IceMonkey 29 15 14 51.72% 0.79% 33.54%
BananaFarm, TackShooter, WizardMonkey 72 31 41 43.06% 1.95% 31.62%
DartMonkey, GlueGunner, SniperMonkey 28 14 14 50.00% 0.76% 31.48%
GlueGunner, MonkeyVillage, TackShooter 34 16 18 47.06% 0.92% 30.28%
BananaFarm, BombShooter, MonkeySub 68 27 41 39.71% 1.84% 28.08%
DartMonkey, IceMonkey, MonkeyVillage 32 13 19 40.63% 0.87% 23.61%
GlueGunner, HeliPilot, MonkeyVillage 34 13 21 38.24% 0.92% 21.90%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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