season_25_matches: oasis_hero

47 rows

descending

Hero	Loadout	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Jericho	BananaFarm, BombShooter, MonkeySub	71	55	16	77.46%	0.96%	67.75%
Churchill_Sentai	BananaFarm, EngineerMonkey, MonkeyAce	43	33	10	76.74%	0.58%	64.12%
PatFusty_Snowman	DartlingGunner, IceMonkey, MonkeyVillage	66	47	19	71.21%	0.89%	60.29%
Etienne	BananaFarm, BombShooter, SpikeFactory	219	137	82	62.56%	2.95%	56.15%
PatFusty_Snowman	DartMonkey, IceMonkey, MonkeyVillage	54	37	17	68.52%	0.73%	56.13%
Churchill_Sentai	BananaFarm, EngineerMonkey, SuperMonkey	40	28	12	70.00%	0.54%	55.80%
PatFusty_Snowman	BananaFarm, DartlingGunner, IceMonkey	88	57	31	64.77%	1.19%	54.79%
Obyn	DartlingGunner, Druid, SpikeFactory	65	43	22	66.15%	0.88%	54.65%
Obyn_Ocean	Alchemist, HeliPilot, NinjaMonkey	51	34	17	66.67%	0.69%	53.73%
Jericho	BananaFarm, EngineerMonkey, MonkeyAce	39	26	13	66.67%	0.53%	51.87%
Jericho_Highwayman	BananaFarm, BombShooter, MonkeySub	31	21	10	67.74%	0.42%	51.29%
PatFusty_Snowman	BananaFarm, IceMonkey, NinjaMonkey	43	28	15	65.12%	0.58%	50.87%
Adora	BananaFarm, DartMonkey, MortarMonkey	54	34	20	62.96%	0.73%	50.08%
Etienne	BananaFarm, BoomerangMonkey, SpikeFactory	43	27	16	62.79%	0.58%	48.34%
Ezili	BananaFarm, BombShooter, WizardMonkey	142	80	62	56.34%	1.92%	48.18%
Etienne	BananaFarm, DartMonkey, GlueGunner	120	68	52	56.67%	1.62%	47.80%
Obyn	BananaFarm, Druid, MonkeySub	323	171	152	52.94%	4.36%	47.50%
Etienne_Bee	BananaFarm, BombShooter, SpikeFactory	93	53	40	56.99%	1.25%	46.93%
Adora	BananaFarm, MonkeySub, SuperMonkey	57	34	23	59.65%	0.77%	46.91%
Bonnie	BombShooter, MonkeySub, SpikeFactory	34	21	13	61.76%	0.46%	45.43%
Gwendolin_Science	GlueGunner, HeliPilot, MonkeyVillage	89	47	42	52.81%	1.20%	42.44%
Gwendolin_Science	DartMonkey, GlueGunner, MonkeyVillage	66	35	31	53.03%	0.89%	40.99%
Jericho	BananaFarm, TackShooter, WizardMonkey	27	16	11	59.26%	0.36%	40.73%
Gwendolin_Science	GlueGunner, MonkeyVillage, NinjaMonkey	206	96	110	46.60%	2.78%	39.79%
Obyn_Ocean	Alchemist, GlueGunner, NinjaMonkey	37	20	17	54.05%	0.50%	38.00%
Jericho_StarCaptain	BananaFarm, BombShooter, MonkeySub	29	16	13	55.17%	0.39%	37.07%
Bonnie	Druid, MonkeySub, SpikeFactory	27	15	12	55.56%	0.36%	36.81%
Etienne_Bee	BananaFarm, BoomerangMonkey, SuperMonkey	23	13	10	56.52%	0.31%	36.26%
Obyn_Ocean	Alchemist, BananaFarm, NinjaMonkey	48	24	24	50.00%	0.65%	35.85%
Etienne	MonkeyVillage, SniperMonkey, TackShooter	37	19	18	51.35%	0.50%	35.25%
Etienne	EngineerMonkey, TackShooter, WizardMonkey	40	20	20	50.00%	0.54%	34.50%
Quincy	BananaFarm, EngineerMonkey, MonkeyAce	22	12	10	54.55%	0.30%	33.74%
Churchill	BananaFarm, EngineerMonkey, SuperMonkey	38	18	20	47.37%	0.51%	31.49%
Gwendolin_Science	Alchemist, GlueGunner, NinjaMonkey	36	17	19	47.22%	0.49%	30.91%
Etienne	BananaFarm, SniperMonkey, TackShooter	29	14	15	48.28%	0.39%	30.09%
Gwendolin_Science	GlueGunner, MonkeyVillage, TackShooter	56	24	32	42.86%	0.76%	29.90%
Etienne	BananaFarm, BombShooter, DartlingGunner	30	14	16	46.67%	0.40%	28.81%
Etienne	DartMonkey, GlueGunner, MonkeyVillage	20	10	10	50.00%	0.27%	28.09%
Etienne_Bee	BananaFarm, BombShooter, MonkeySub	20	10	10	50.00%	0.27%	28.09%
Etienne_Bee	DartMonkey, GlueGunner, MonkeyVillage	20	10	10	50.00%	0.27%	28.09%
Obyn	Alchemist, Druid, MonkeyVillage	28	12	16	42.86%	0.38%	24.53%
Bonnie	Alchemist, NinjaMonkey, SpikeFactory	23	10	13	43.48%	0.31%	23.22%
Bonnie	Alchemist, MonkeyBuccaneer, SpikeFactory	31	12	19	38.71%	0.42%	21.56%
Etienne	BananaFarm, GlueGunner, TackShooter	25	10	15	40.00%	0.34%	20.80%
PatFusty	DartMonkey, GlueGunner, MonkeyVillage	33	12	21	36.36%	0.45%	19.95%
Quincy_Cyber	BananaFarm, BombShooter, WizardMonkey	26	10	16	38.46%	0.35%	19.76%
Etienne_Bee	DartlingGunner, Druid, MonkeyVillage	38	10	28	26.32%	0.51%	12.31%

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)

47 rows

Advanced export