season_29_matches: oasis_hero

38 rows

descending

Hero	Loadout	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Etienne_Bee	BananaFarm, BoomerangMonkey, EngineerMonkey	89	64	25	71.91%	1.14%	62.57%
Churchill_Sentai	BananaFarm, EngineerMonkey, MonkeyAce	36	26	10	72.22%	0.46%	57.59%
Gwendolin	BananaFarm, MonkeySub, TackShooter	36	26	10	72.22%	0.46%	57.59%
Jericho_Highwayman	BananaFarm, BombShooter, MonkeySub	38	27	11	71.05%	0.49%	56.63%
Jericho	BananaFarm, TackShooter, WizardMonkey	65	44	21	67.69%	0.84%	56.32%
Jericho	BananaFarm, BombShooter, MonkeySub	199	123	76	61.81%	2.56%	55.06%
Jericho	BananaFarm, EngineerMonkey, MonkeyAce	72	46	26	63.89%	0.93%	52.79%
PatFusty_Snowman	BananaFarm, DartlingGunner, IceMonkey	147	88	59	59.86%	1.89%	51.94%
Etienne	BananaFarm, BombShooter, SpikeFactory	86	53	33	61.63%	1.11%	51.35%
Jericho	BananaFarm, IceMonkey, MonkeySub	224	129	95	57.59%	2.88%	51.12%
Obyn	BananaFarm, Druid, MonkeySub	651	354	297	54.38%	8.37%	50.55%
Ezili	BananaFarm, NinjaMonkey, WizardMonkey	91	55	36	60.44%	1.17%	50.39%
Benjamin	DartlingGunner, MonkeyVillage, SuperMonkey	56	35	21	62.50%	0.72%	49.82%
Etienne_Bee	BananaFarm, BombShooter, DartlingGunner	30	20	10	66.67%	0.39%	49.80%
Etienne_Bee	BananaFarm, BombShooter, SpikeFactory	242	135	107	55.79%	3.11%	49.53%
StrikerJones	BananaFarm, BombShooter, MortarMonkey	37	24	13	64.86%	0.48%	49.48%
Churchill_Sentai	BananaFarm, IceMonkey, MonkeySub	566	301	265	53.18%	7.28%	49.07%
Quincy_Cyber	BananaFarm, TackShooter, WizardMonkey	112	64	48	57.14%	1.44%	47.98%
Ezili	BananaFarm, BombShooter, WizardMonkey	47	29	18	61.70%	0.60%	47.80%
Quincy	BananaFarm, TackShooter, WizardMonkey	147	76	71	51.70%	1.89%	43.62%
Churchill_Sentai	BananaFarm, BombShooter, MonkeySub	51	27	24	52.94%	0.66%	39.24%
Churchill	BananaFarm, IceMonkey, MonkeySub	94	46	48	48.94%	1.21%	38.83%
Gwendolin_Science	DartMonkey, GlueGunner, MonkeyVillage	26	15	11	57.69%	0.33%	38.70%
Quincy	BananaFarm, BombShooter, MonkeySub	55	28	27	50.91%	0.71%	37.70%
Obyn_Ocean	Alchemist, BananaFarm, NinjaMonkey	81	39	42	48.15%	1.04%	37.27%
Ezili_SmudgeCat	DartMonkey, MonkeySub, NinjaMonkey	25	14	11	56.00%	0.32%	36.54%
Gwendolin_Science	GlueGunner, HeliPilot, MonkeyVillage	32	17	15	53.13%	0.41%	35.83%
Etienne_Bee	BananaFarm, BoomerangMonkey, SpikeFactory	66	31	35	46.97%	0.85%	34.93%
Bonnie	DartlingGunner, SpikeFactory, SuperMonkey	35	18	17	51.43%	0.45%	34.87%
PatFusty_Snowman	DartlingGunner, IceMonkey, MonkeyVillage	35	18	17	51.43%	0.45%	34.87%
Etienne_Bee	BananaFarm, BoomerangMonkey, NinjaMonkey	58	27	31	46.55%	0.75%	33.71%
Jericho_Highwayman	BananaFarm, TackShooter, WizardMonkey	23	12	11	52.17%	0.30%	31.76%
Etienne	EngineerMonkey, TackShooter, WizardMonkey	37	17	20	45.95%	0.48%	29.89%
Obyn_Ocean	Alchemist, HeliPilot, NinjaMonkey	24	11	13	45.83%	0.31%	25.90%
Gwendolin_Science	GlueGunner, MonkeyVillage, TackShooter	58	20	38	34.48%	0.75%	22.25%
Churchill_Sentai	EngineerMonkey, MonkeyVillage, SpikeFactory	24	10	14	41.67%	0.31%	21.94%
Etienne_Bee	BananaFarm, IceMonkey, MonkeySub	45	13	32	28.89%	0.58%	15.65%
Jericho_Highwayman	BananaFarm, IceMonkey, MonkeySub	35	10	25	28.57%	0.45%	13.60%

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)

38 rows

Advanced export