glade_loadouts (view)

20 rows

✎ View and edit SQL

This data as json, CSV (advanced)

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

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
BananaFarm, BoomerangMonkey, MortarMonkey 62 46 16 74.19% 2.04% 63.30%
DartlingGunner, MonkeyVillage, SuperMonkey 59 41 18 69.49% 1.94% 57.74%
BananaFarm, DartlingGunner, NinjaMonkey 55 38 17 69.09% 1.81% 56.88%
BananaFarm, DartMonkey, SpikeFactory 755 453 302 60.00% 24.79% 56.51%
BananaFarm, DartlingGunner, IceMonkey 54 35 19 64.81% 1.77% 52.08%
BananaFarm, TackShooter, WizardMonkey 232 134 98 57.76% 7.62% 51.40%
BananaFarm, EngineerMonkey, WizardMonkey 29 19 10 65.52% 0.95% 48.22%
BananaFarm, DartMonkey, WizardMonkey 24 14 10 58.33% 0.79% 38.61%
BananaFarm, BoomerangMonkey, SpikeFactory 112 52 60 46.43% 3.68% 37.19%
BananaFarm, BoomerangMonkey, WizardMonkey 57 28 29 49.12% 1.87% 36.14%
BananaFarm, SniperMonkey, WizardMonkey 34 17 17 50.00% 1.12% 33.19%
BananaFarm, DartMonkey, MortarMonkey 24 12 12 50.00% 0.79% 30.00%
BananaFarm, DartMonkey, SniperMonkey 24 12 12 50.00% 0.79% 30.00%
BananaFarm, DartlingGunner, SpikeFactory 27 13 14 48.15% 0.89% 29.30%
Alchemist, MonkeyBuccaneer, SpikeFactory 20 10 10 50.00% 0.66% 28.09%
BananaFarm, DartlingGunner, WizardMonkey 23 11 12 47.83% 0.76% 27.41%
HeliPilot, IceMonkey, MonkeyVillage 26 12 14 46.15% 0.85% 26.99%
BoomerangMonkey, SniperMonkey, WizardMonkey 25 11 14 44.00% 0.82% 24.54%
BananaFarm, BoomerangMonkey, MonkeySub 26 11 15 42.31% 0.85% 23.32%
SpikeFactory, TackShooter, WizardMonkey 27 10 17 37.04% 0.89% 18.82%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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