season_28_matches: oasis_hero

43 rows

descending

Hero	Loadout	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Etienne_Bee	BananaFarm, BombShooter, MonkeySub	52	40	12	76.92%	0.62%	65.47%
Etienne_Bee	BananaFarm, BoomerangMonkey, EngineerMonkey	76	57	19	75.00%	0.90%	65.26%
Ezili	BananaFarm, BombShooter, WizardMonkey	120	87	33	72.50%	1.43%	64.51%
StrikerJones	BananaFarm, BombShooter, MortarMonkey	41	30	11	73.17%	0.49%	59.61%
PatFusty_Snowman	IceMonkey, MonkeyVillage, NinjaMonkey	70	49	21	70.00%	0.83%	59.26%
Quincy_Cyber	BananaFarm, BombShooter, MonkeySub	40	29	11	72.50%	0.48%	58.66%
Obyn	BananaFarm, Druid, MonkeySub	1029	587	442	57.05%	12.24%	54.02%
Churchill	BananaFarm, BombShooter, MonkeySub	43	29	14	67.44%	0.51%	53.44%
PatFusty_Snowman	BananaFarm, DartlingGunner, IceMonkey	144	88	56	61.11%	1.71%	53.15%
PatFusty_Snowman	HeliPilot, IceMonkey, SuperMonkey	52	34	18	65.38%	0.62%	52.45%
Jericho	BananaFarm, EngineerMonkey, MonkeyAce	125	76	49	60.80%	1.49%	52.24%
Etienne	BananaFarm, BombShooter, SpikeFactory	141	83	58	58.87%	1.68%	50.74%
Quincy	BananaFarm, TackShooter, WizardMonkey	202	114	88	56.44%	2.40%	49.60%
Etienne_Bee	BananaFarm, BombShooter, SpikeFactory	184	103	81	55.98%	2.19%	48.81%
Churchill_Sentai	BananaFarm, BombShooter, MonkeySub	126	72	54	57.14%	1.50%	48.50%
Etienne	BananaFarm, DartMonkey, GlueGunner	38	24	14	63.16%	0.45%	47.82%
Jericho	BananaFarm, BombShooter, MonkeySub	297	157	140	52.86%	3.53%	47.18%
Jericho	BananaFarm, TackShooter, WizardMonkey	66	38	28	57.58%	0.78%	45.65%
Etienne_Bee	BananaFarm, EngineerMonkey, MonkeyAce	34	21	13	61.76%	0.40%	45.43%
Etienne_Bee	BananaFarm, BoomerangMonkey, NinjaMonkey	91	50	41	54.95%	1.08%	44.72%
Adora	BananaFarm, IceMonkey, SuperMonkey	42	24	18	57.14%	0.50%	42.18%
Churchill_Sentai	BananaFarm, EngineerMonkey, MonkeyAce	53	29	24	54.72%	0.63%	41.32%
Benjamin	DartlingGunner, MonkeyVillage, SuperMonkey	85	42	43	49.41%	1.01%	38.78%
Quincy_Cyber	BananaFarm, TackShooter, WizardMonkey	59	30	29	50.85%	0.70%	38.09%
Quincy	BananaFarm, BombShooter, MonkeySub	83	40	43	48.19%	0.99%	37.44%
Obyn_Ocean	Alchemist, BananaFarm, NinjaMonkey	148	66	82	44.59%	1.76%	36.59%
Obyn	Alchemist, Druid, MonkeyVillage	23	13	10	56.52%	0.27%	36.26%
Etienne_Bee	BananaFarm, BoomerangMonkey, SpikeFactory	79	37	42	46.84%	0.94%	35.83%
Obyn_Ocean	Alchemist, HeliPilot, NinjaMonkey	26	14	12	53.85%	0.31%	34.68%
Gwendolin_Science	GlueGunner, HeliPilot, MonkeyVillage	87	37	50	42.53%	1.03%	32.14%
Bonnie	BombShooter, MonkeySub, SpikeFactory	21	11	10	52.38%	0.25%	31.02%
Jericho	BananaFarm, Druid, MonkeySub	21	11	10	52.38%	0.25%	31.02%
Jericho_StarCaptain	BananaFarm, TackShooter, WizardMonkey	31	15	16	48.39%	0.37%	30.79%
Quincy	BananaFarm, IceMonkey, WizardMonkey	26	13	13	50.00%	0.31%	30.78%
Gwendolin_Science	DartMonkey, GlueGunner, MonkeyVillage	42	19	23	45.24%	0.50%	30.19%
Ezili	BananaFarm, NinjaMonkey, WizardMonkey	24	12	12	50.00%	0.29%	30.00%
Gwendolin_Science	GlueGunner, MonkeyVillage, TackShooter	128	49	79	38.28%	1.52%	29.86%
Jericho_StarCaptain	BananaFarm, BombShooter, MonkeySub	39	17	22	43.59%	0.46%	28.03%
Benjamin	BananaFarm, DartlingGunner, SuperMonkey	38	15	23	39.47%	0.45%	23.93%
PatFusty_Snowman	DartlingGunner, IceMonkey, MonkeyVillage	29	12	17	41.38%	0.34%	23.45%
StrikerJones_Biker	BombShooter, MonkeyVillage, SpikeFactory	33	12	21	36.36%	0.39%	19.95%
Churchill_Sentai	BananaFarm, EngineerMonkey, SpikeFactory	26	10	16	38.46%	0.31%	19.76%
Obyn	Druid, MonkeySub, SpikeFactory	35	11	24	31.43%	0.42%	16.05%

Advanced export

JSON shape: default, array, newline-delimited

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

oasis_hero_loadouts (view)

43 rows

Advanced export