cobra_command_loadouts (view)

27 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Winrate

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
BananaFarm, EngineerMonkey, MonkeyAce 157 121 36 77.07% 2.66% 70.49%
BananaFarm, BoomerangMonkey, MortarMonkey 74 57 17 77.03% 1.25% 67.44%
BananaFarm, BombShooter, SpikeFactory 1082 697 385 64.42% 18.31% 61.57%
BananaFarm, DartMonkey, MortarMonkey 61 41 20 67.21% 1.03% 55.43%
BananaFarm, BombShooter, MortarMonkey 83 52 31 62.65% 1.40% 52.24%
BananaFarm, BombShooter, MonkeySub 435 240 195 55.17% 7.36% 50.50%
BananaFarm, BombShooter, WizardMonkey 166 90 76 54.22% 2.81% 46.64%
BananaFarm, BoomerangMonkey, NinjaMonkey 243 123 120 50.62% 4.11% 44.33%
BananaFarm, DartMonkey, GlueGunner 94 50 44 53.19% 1.59% 43.10%
BombShooter, MonkeyVillage, SpikeFactory 68 37 31 54.41% 1.15% 42.57%
BananaFarm, BoomerangMonkey, SpikeFactory 190 94 96 49.47% 3.22% 42.36%
BananaFarm, BoomerangMonkey, EngineerMonkey 76 40 36 52.63% 1.29% 41.41%
BananaFarm, DartMonkey, SpikeFactory 44 24 20 54.55% 0.74% 39.83%
BananaFarm, Druid, MonkeySub 51 27 24 52.94% 0.86% 39.24%
DartMonkey, GlueGunner, MonkeyVillage 42 22 20 52.38% 0.71% 37.28%
BananaFarm, SniperMonkey, WizardMonkey 40 21 19 52.50% 0.68% 37.02%
BananaFarm, BombShooter, SniperMonkey 34 18 16 52.94% 0.58% 36.16%
Alchemist, BananaFarm, NinjaMonkey 52 25 27 48.08% 0.88% 34.50%
Alchemist, BombShooter, SpikeFactory 30 15 15 50.00% 0.51% 32.11%
GlueGunner, HeliPilot, MonkeyVillage 98 41 57 41.84% 1.66% 32.07%
BananaFarm, IceMonkey, WizardMonkey 33 16 17 48.48% 0.56% 31.43%
DartlingGunner, MonkeyVillage, SuperMonkey 48 19 29 39.58% 0.81% 25.75%
BombShooter, MonkeySub, SpikeFactory 25 11 14 44.00% 0.42% 24.54%
GlueGunner, MonkeyVillage, TackShooter 133 43 90 32.33% 2.25% 24.38%
BananaFarm, TackShooter, WizardMonkey 136 42 94 30.88% 2.30% 23.12%
BananaFarm, NinjaMonkey, WizardMonkey 30 12 18 40.00% 0.51% 22.47%
DartlingGunner, SpikeFactory, SuperMonkey 24 10 14 41.67% 0.41% 21.94%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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