season_26_matches: oasis_hero

40 rows

descending

Hero	Loadout	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Churchill_Sentai	BananaFarm, EngineerMonkey, MonkeyAce	48	37	11	77.08%	0.60%	65.19%
Etienne	BananaFarm, DartMonkey, GlueGunner	131	94	37	71.76%	1.63%	64.05%
Jericho	BananaFarm, EngineerMonkey, MonkeyAce	89	61	28	68.54%	1.11%	58.89%
Jericho	BananaFarm, DartMonkey, MortarMonkey	37	27	10	72.97%	0.46%	58.66%
PatFusty_Snowman	DartlingGunner, IceMonkey, MonkeyVillage	61	42	19	68.85%	0.76%	57.23%
Jericho	BananaFarm, BombShooter, MonkeySub	209	132	77	63.16%	2.60%	56.62%
Etienne_Bee	BananaFarm, BombShooter, SpikeFactory	107	68	39	63.55%	1.33%	54.43%
Etienne	EngineerMonkey, TackShooter, WizardMonkey	32	22	10	68.75%	0.40%	52.69%
Ezili	BananaFarm, BombShooter, WizardMonkey	140	84	56	60.00%	1.74%	51.88%
Bonnie	DartMonkey, GlueGunner, MonkeyVillage	35	23	12	65.71%	0.44%	49.99%
PatFusty_Snowman	BananaFarm, DartlingGunner, IceMonkey	170	97	73	57.06%	2.11%	49.62%
Etienne	BananaFarm, BombShooter, SpikeFactory	271	150	121	55.35%	3.37%	49.43%
Jericho	BananaFarm, TackShooter, WizardMonkey	48	30	18	62.50%	0.60%	48.80%
Bonnie	BombShooter, MonkeySub, SpikeFactory	41	26	15	63.41%	0.51%	48.67%
Etienne	MonkeyVillage, SniperMonkey, TackShooter	45	28	17	62.22%	0.56%	48.06%
Benjamin	DartlingGunner, MonkeyVillage, SuperMonkey	67	40	27	59.70%	0.83%	47.96%
Obyn	BananaFarm, Druid, MonkeySub	359	190	169	52.92%	4.46%	47.76%
PatFusty_Snowman	BananaFarm, IceMonkey, NinjaMonkey	33	21	12	63.64%	0.41%	47.22%
Gwendolin_Science	DartMonkey, GlueGunner, MonkeyVillage	63	37	26	58.73%	0.78%	46.57%
Quincy_Cyber	BananaFarm, BombShooter, MonkeySub	35	21	14	60.00%	0.44%	43.77%
PatFusty_Snowman	HeliPilot, IceMonkey, SuperMonkey	51	29	22	56.86%	0.63%	43.27%
Jericho_StarCaptain	BananaFarm, BombShooter, MonkeySub	57	32	25	56.14%	0.71%	43.26%
Obyn_Ocean	Alchemist, BananaFarm, NinjaMonkey	109	57	52	52.29%	1.36%	42.92%
Obyn_Ocean	Alchemist, GlueGunner, NinjaMonkey	25	15	10	60.00%	0.31%	40.80%
StrikerJones	BananaFarm, BombShooter, MortarMonkey	27	16	11	59.26%	0.34%	40.73%
Gwendolin_Science	GlueGunner, MonkeyVillage, NinjaMonkey	71	36	35	50.70%	0.88%	39.07%
Gwendolin_Science	GlueGunner, HeliPilot, MonkeyVillage	168	71	97	42.26%	2.09%	34.79%
Quincy	BananaFarm, BombShooter, MonkeySub	26	14	12	53.85%	0.32%	34.68%
Bonnie	Druid, MonkeySub, SpikeFactory	22	12	10	54.55%	0.27%	33.74%
Etienne	BananaFarm, SniperMonkey, TackShooter	22	12	10	54.55%	0.27%	33.74%
Gwendolin_Science	Alchemist, GlueGunner, NinjaMonkey	35	17	18	48.57%	0.44%	32.01%
Etienne	BananaFarm, BoomerangMonkey, SpikeFactory	31	15	16	48.39%	0.39%	30.79%
Obyn_Ocean	Alchemist, HeliPilot, NinjaMonkey	44	20	24	45.45%	0.55%	30.74%
Benjamin	BananaFarm, DartlingGunner, SuperMonkey	40	18	22	45.00%	0.50%	29.58%
Gwendolin_Science	GlueGunner, MonkeyVillage, TackShooter	49	20	29	40.82%	0.61%	27.05%
Obyn	Alchemist, Druid, MonkeyVillage	45	18	27	40.00%	0.56%	25.69%
Churchill_Sentai	BananaFarm, EngineerMonkey, SuperMonkey	37	15	22	40.54%	0.46%	24.72%
Bonnie	BombShooter, SpikeFactory, WizardMonkey	23	10	13	43.48%	0.29%	23.22%
Bonnie	DartlingGunner, MonkeyVillage, SuperMonkey	27	11	16	40.74%	0.34%	22.21%
Bonnie	Alchemist, DartlingGunner, SpikeFactory	33	11	22	33.33%	0.41%	17.25%

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)

40 rows

Advanced export