cobra_command_hero_loadouts (view)

29 rows

✎ View and edit SQL

This data as json, CSV (advanced)

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

Hero Loadout Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Etienne_Bee BananaFarm, EngineerMonkey, MonkeyAce 150 123 27 82.00% 2.69% 75.85%
Quincy_Cyber BananaFarm, DartMonkey, SpikeFactory 50 40 10 80.00% 0.90% 68.91%
Quincy BananaFarm, BoomerangMonkey, MortarMonkey 52 41 11 78.85% 0.93% 67.75%
Etienne_Bee BananaFarm, BoomerangMonkey, EngineerMonkey 89 60 29 67.42% 1.60% 57.68%
Quincy BananaFarm, DartMonkey, SpikeFactory 35 25 10 71.43% 0.63% 56.46%
Etienne_Bee BananaFarm, BombShooter, SpikeFactory 683 404 279 59.15% 12.27% 55.46%
Etienne BananaFarm, BombShooter, SpikeFactory 294 179 115 60.88% 5.28% 55.31%
Jericho_Highwayman BananaFarm, BombShooter, MonkeySub 157 95 62 60.51% 2.82% 52.86%
Etienne_Bee BombShooter, DartlingGunner, SpikeFactory 34 23 11 67.65% 0.61% 51.92%
Jericho BananaFarm, BombShooter, MonkeySub 155 87 68 56.13% 2.78% 48.32%
Quincy_Cyber BananaFarm, BombShooter, SniperMonkey 33 21 12 63.64% 0.59% 47.22%
Obyn BananaFarm, Druid, MonkeySub 50 30 20 60.00% 0.90% 46.42%
Etienne_Bee BananaFarm, BoomerangMonkey, NinjaMonkey 144 77 67 53.47% 2.59% 45.33%
Etienne_Bee BananaFarm, BoomerangMonkey, SpikeFactory 106 57 49 53.77% 1.90% 44.28%
Etienne BananaFarm, DartMonkey, GlueGunner 34 20 14 58.82% 0.61% 42.28%
Jericho BananaFarm, EngineerMonkey, MonkeyAce 37 21 16 56.76% 0.66% 40.79%
Quincy BananaFarm, BombShooter, MonkeySub 60 32 28 53.33% 1.08% 40.71%
StrikerJones BananaFarm, BombShooter, MortarMonkey 38 21 17 55.26% 0.68% 39.45%
Quincy_Cyber BananaFarm, TackShooter, WizardMonkey 35 19 16 54.29% 0.63% 37.78%
Quincy_Cyber BananaFarm, BombShooter, MonkeySub 58 29 29 50.00% 1.04% 37.13%
Etienne_Bee BananaFarm, BombShooter, MonkeySub 45 21 24 46.67% 0.81% 32.09%
Quincy_Cyber BananaFarm, DartMonkey, MortarMonkey 24 12 12 50.00% 0.43% 30.00%
PatFusty_Snowman HeliPilot, IceMonkey, NinjaMonkey 20 10 10 50.00% 0.36% 28.09%
Etienne_Bee BananaFarm, BombShooter, DartlingGunner 51 20 31 39.22% 0.92% 25.82%
Ezili BananaFarm, NinjaMonkey, WizardMonkey 53 19 34 35.85% 0.95% 22.94%
Bonnie DartlingGunner, NinjaMonkey, SpikeFactory 24 10 14 41.67% 0.43% 21.94%
Ezili BananaFarm, BombShooter, WizardMonkey 34 13 21 38.24% 0.61% 21.90%
Quincy BananaFarm, TackShooter, WizardMonkey 50 17 33 34.00% 0.90% 20.87%
Gwendolin_Science GlueGunner, MonkeyVillage, TackShooter 32 12 20 37.50% 0.57% 20.73%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW cobra_command_hero_loadouts AS 
WITH cobra_command AS
    (SELECT *
    FROM matches
    WHERE map = 'cobra_command')
SELECT Hero,
       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 Hero,
             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 Hero,
                   Loadout,
                   SUM(Wins) + SUM(NOT Wins) AS Games,
                   SUM(Wins)                 AS Wins,
                   SUM(NOT Wins)             AS Losses
            FROM (SELECT lHero                               AS Hero,
                         printf('%s, %s, %s', lt1, lt2, lt3) AS Loadout,
                         playerLeftWin                       AS Wins
                  FROM cobra_command
                  UNION ALL
                  SELECT rHero                               AS Hero,
                         printf('%s, %s, %s', rt1, rt2, rt3) AS Loadout,
                         NOT playerLeftWin                   AS Wins
                  FROM cobra_command)
            GROUP BY Hero,
                     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;