season_30_matches: oasis_hero

41 rows

descending

Hero	Loadout	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Jericho	BananaFarm, BombShooter, MonkeySub	115	94	21	81.74%	1.66%	74.68%
Etienne_Bee	BananaFarm, BombShooter, SpikeFactory	207	136	71	65.70%	2.99%	59.23%
Jericho	BananaFarm, Druid, MonkeySub	35	25	10	71.43%	0.50%	56.46%
Etienne	BananaFarm, BombShooter, SpikeFactory	79	52	27	65.82%	1.14%	55.36%
PatFusty_Snowman	BananaFarm, DartlingGunner, IceMonkey	140	88	52	62.86%	2.02%	54.85%
Benjamin	DartlingGunner, MonkeyVillage, SuperMonkey	69	44	25	63.77%	1.00%	52.43%
Jericho	BananaFarm, EngineerMonkey, MonkeyAce	77	48	29	62.34%	1.11%	51.51%
Etienne_Bee	BananaFarm, EngineerMonkey, MonkeyAce	31	21	10	67.74%	0.45%	51.29%
Obyn	BananaFarm, Druid, MonkeySub	333	188	145	56.46%	4.80%	51.13%
Quincy_Cyber	BananaFarm, TackShooter, WizardMonkey	92	56	36	60.87%	1.33%	50.90%
Quincy	BananaFarm, BombShooter, MonkeySub	40	26	14	65.00%	0.58%	50.22%
Churchill_Sentai	BananaFarm, IceMonkey, MonkeySub	318	177	141	55.66%	4.59%	50.20%
Jericho	BananaFarm, IceMonkey, MonkeySub	336	183	153	54.46%	4.85%	49.14%
Quincy_Cyber	BananaFarm, IceMonkey, MonkeySub	54	32	22	59.26%	0.78%	46.15%
Ezili	BananaFarm, BombShooter, WizardMonkey	42	25	17	59.52%	0.61%	44.68%
Ezili	BananaFarm, NinjaMonkey, WizardMonkey	46	27	19	58.70%	0.66%	44.47%
PatFusty_Snowman	DartlingGunner, IceMonkey, MonkeyVillage	35	21	14	60.00%	0.50%	43.77%
Churchill_Sentai	BananaFarm, DartMonkey, SpikeFactory	26	16	10	61.54%	0.37%	42.84%
Bonnie	DartMonkey, MonkeyVillage, SuperMonkey	38	22	16	57.89%	0.55%	42.20%
Quincy	BananaFarm, TackShooter, WizardMonkey	116	58	58	50.00%	1.67%	40.90%
Etienne_Bee	BananaFarm, BoomerangMonkey, NinjaMonkey	41	22	19	53.66%	0.59%	38.39%
Churchill	BananaFarm, IceMonkey, MonkeySub	42	22	20	52.38%	0.61%	37.28%
Churchill_Sentai	BananaFarm, EngineerMonkey, MonkeyAce	27	15	12	55.56%	0.39%	36.81%
StrikerJones_Biker	BananaFarm, EngineerMonkey, MonkeyAce	32	17	15	53.13%	0.46%	35.83%
Quincy_Cyber	BananaFarm, BombShooter, MonkeySub	28	15	13	53.57%	0.40%	35.10%
StrikerJones	BananaFarm, BombShooter, MonkeySub	28	15	13	53.57%	0.40%	35.10%
StrikerJones_Biker	EngineerMonkey, MonkeyAce, MonkeyVillage	24	13	11	54.17%	0.35%	34.23%
Etienne_Bee	BananaFarm, BoomerangMonkey, SpikeFactory	43	21	22	48.84%	0.62%	33.90%
Jericho	BananaFarm, TackShooter, WizardMonkey	56	26	30	46.43%	0.81%	33.37%
Obyn_Ocean	Alchemist, BananaFarm, NinjaMonkey	67	30	37	44.78%	0.97%	32.87%
PatFusty_Snowman	BananaFarm, IceMonkey, NinjaMonkey	57	25	32	43.86%	0.82%	30.98%
Etienne	BananaFarm, BoomerangMonkey, SpikeFactory	24	12	12	50.00%	0.35%	30.00%
Etienne	EngineerMonkey, TackShooter, WizardMonkey	28	13	15	46.43%	0.40%	27.96%
Obyn_Ocean	Alchemist, HeliPilot, NinjaMonkey	23	11	12	47.83%	0.33%	27.41%
Obyn_Ocean	Alchemist, IceMonkey, NinjaMonkey	26	12	14	46.15%	0.37%	26.99%
Obyn_Ocean	Alchemist, GlueGunner, NinjaMonkey	29	13	16	44.83%	0.42%	26.73%
Gwendolin_Science	GlueGunner, MonkeyVillage, TackShooter	70	25	45	35.71%	1.01%	24.49%
Jericho_Highwayman	BananaFarm, IceMonkey, MonkeySub	41	15	26	36.59%	0.59%	21.84%
StrikerJones_Biker	HeliPilot, IceMonkey, MonkeyVillage	49	17	32	34.69%	0.71%	21.37%
Gwendolin	BananaFarm, IceMonkey, NinjaMonkey	27	10	17	37.04%	0.39%	18.82%
Etienne_Bee	BananaFarm, IceMonkey, MonkeySub	33	10	23	30.30%	0.48%	14.62%

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)

41 rows

Advanced export