s24+_matches: cobra_command_hero

234 rows

descending

Hero	Loadout	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Quincy	BananaFarm, BoomerangMonkey, MortarMonkey	401	329	72	82.04%	0.94%	78.29%
Etienne_Bee	BananaFarm, EngineerMonkey, MonkeyAce	456	373	83	81.80%	1.07%	78.26%
Jericho	BananaFarm, DartMonkey, WizardMonkey	64	53	11	82.81%	0.15%	73.57%
Etienne_Bee	BananaFarm, BoomerangMonkey, MonkeyAce	71	57	14	80.28%	0.17%	71.03%
Quincy_Cyber	BananaFarm, DartMonkey, SpikeFactory	76	59	17	77.63%	0.18%	68.26%
Etienne_Bee	BombShooter, DartlingGunner, SpikeFactory	92	68	24	73.91%	0.22%	64.94%
Quincy	BananaFarm, BombShooter, MortarMonkey	44	34	10	77.27%	0.10%	64.89%
Quincy_Cyber	BananaFarm, DartMonkey, WizardMonkey	77	56	21	72.73%	0.18%	62.78%
Jericho	BananaFarm, EngineerMonkey, MonkeyAce	201	139	62	69.15%	0.47%	62.77%
Quincy_Cyber	BananaFarm, EngineerMonkey, MonkeyAce	80	58	22	72.50%	0.19%	62.72%
Etienne_Bee	BananaFarm, BombShooter, SpikeFactory	3448	2115	1333	61.34%	8.12%	59.71%
Benjamin	DartlingGunner, MonkeyVillage, SuperMonkey	288	187	101	64.93%	0.68%	59.42%
Etienne	BananaFarm, BombShooter, SpikeFactory	3821	2314	1507	60.56%	9.00%	59.01%
Jericho_Highwayman	BananaFarm, BombShooter, MonkeySub	360	230	130	63.89%	0.85%	58.93%
Quincy_Cyber	BananaFarm, EngineerMonkey, WizardMonkey	37	27	10	72.97%	0.09%	58.66%
Bonnie	GlueGunner, MonkeyVillage, TackShooter	100	67	33	67.00%	0.24%	57.78%
Etienne	BananaFarm, BombShooter, MonkeyAce	47	33	14	70.21%	0.11%	57.14%
Jericho_Highwayman	BananaFarm, DartMonkey, WizardMonkey	69	47	22	68.12%	0.16%	57.12%
Bonnie	BoomerangMonkey, NinjaMonkey, SpikeFactory	41	29	12	70.73%	0.10%	56.80%
Etienne	BananaFarm, DartMonkey, GlueGunner	766	460	306	60.05%	1.80%	56.58%
Etienne_Bee	BananaFarm, BoomerangMonkey, EngineerMonkey	261	163	98	62.45%	0.61%	56.58%
Adora	BananaFarm, DartMonkey, MortarMonkey	251	156	95	62.15%	0.59%	56.15%
Quincy	BananaFarm, DartMonkey, SpikeFactory	56	38	18	67.86%	0.13%	55.63%
Bonnie	BombShooter, MortarMonkey, SpikeFactory	73	48	25	65.75%	0.17%	54.87%
Quincy_Cyber	BananaFarm, DartMonkey, MortarMonkey	59	39	20	66.10%	0.14%	54.02%
Ezili	BananaFarm, BombShooter, WizardMonkey	512	298	214	58.20%	1.21%	53.93%
StrikerJones	BananaFarm, BombShooter, MortarMonkey	298	177	121	59.40%	0.70%	53.82%
Benjamin_DJ	DartlingGunner, MonkeyVillage, SuperMonkey	63	41	22	65.08%	0.15%	53.31%
Etienne	BombShooter, BoomerangMonkey, SpikeFactory	35	24	11	68.57%	0.08%	53.19%
Etienne	BananaFarm, BoomerangMonkey, SpikeFactory	236	140	96	59.32%	0.56%	53.05%
Adora	Alchemist, DartlingGunner, SuperMonkey	50	33	17	66.00%	0.12%	52.87%
Adora_Fateweaver	BananaFarm, DartMonkey, MortarMonkey	54	35	19	64.81%	0.13%	52.08%
Etienne	BananaFarm, BombShooter, SniperMonkey	92	57	35	61.96%	0.22%	52.04%
Etienne	BananaFarm, BoomerangMonkey, SniperMonkey	123	74	49	60.16%	0.29%	51.51%
Etienne_Bee	BananaFarm, BoomerangMonkey, NinjaMonkey	530	295	235	55.66%	1.25%	51.43%
Etienne_Bee	BananaFarm, Druid, MonkeySub	31	21	10	67.74%	0.07%	51.29%
Jericho	BananaFarm, BombShooter, MonkeySub	661	363	298	54.92%	1.56%	51.12%
Quincy_Cyber	BananaFarm, BombShooter, SniperMonkey	38	25	13	65.79%	0.09%	50.71%
Obyn	DartlingGunner, Druid, SpikeFactory	71	44	27	61.97%	0.17%	50.68%
Etienne_Bee	BananaFarm, BoomerangMonkey, SpikeFactory	462	255	207	55.19%	1.09%	50.66%
Etienne_Bee	BananaFarm, BombShooter, NinjaMonkey	47	30	17	63.83%	0.11%	50.09%
Jericho_StarCaptain	BananaFarm, DartMonkey, MortarMonkey	35	23	12	65.71%	0.08%	49.99%
Adora	BananaFarm, DartMonkey, SpikeFactory	99	59	40	59.60%	0.23%	49.93%
Bonnie	BombShooter, MonkeyVillage, SpikeFactory	72	44	28	61.11%	0.17%	49.85%
Bonnie	BombShooter, MonkeySub, SpikeFactory	130	74	56	56.92%	0.31%	48.41%
Etienne_Bee	BananaFarm, BombShooter, GlueGunner	43	27	16	62.79%	0.10%	48.34%
Etienne	BananaFarm, DartMonkey, SpikeFactory	74	44	30	59.46%	0.17%	48.27%
StrikerJones_Biker	BananaFarm, HeliPilot, IceMonkey	67	40	27	59.70%	0.16%	47.96%
Bonnie	BananaFarm, SniperMonkey, WizardMonkey	56	34	22	60.71%	0.13%	47.92%
Jericho_Highwayman	DartMonkey, SpikeFactory, WizardMonkey	31	20	11	64.52%	0.07%	47.67%

Advanced export

JSON shape: default, array, newline-delimited

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;

cobra_command_hero_loadouts (view)

234 rows

Advanced export