season_31_matches: oasis_hero

44 rows

descending

Hero	Loadout	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Churchill_Sentai	BananaFarm, EngineerMonkey, MonkeyAce	66	49	17	74.24%	0.90%	63.69%
Jericho	BananaFarm, BombShooter, MonkeySub	183	128	55	69.95%	2.49%	63.30%
Benjamin	BananaFarm, DartlingGunner, NinjaMonkey	36	26	10	72.22%	0.49%	57.59%
Etienne_Bee	BananaFarm, BombShooter, SpikeFactory	198	127	71	64.14%	2.70%	57.46%
PatFusty_Snowman	BananaFarm, DartlingGunner, IceMonkey	141	90	51	63.83%	1.92%	55.90%
Churchill_Sentai	BananaFarm, SniperMonkey, SuperMonkey	34	23	11	67.65%	0.46%	51.92%
Quincy_Cyber	BananaFarm, NinjaMonkey, WizardMonkey	51	33	18	64.71%	0.69%	51.59%
Quincy_Cyber	BananaFarm, TackShooter, WizardMonkey	184	106	78	57.61%	2.51%	50.47%
Obyn	BananaFarm, Druid, MonkeySub	356	197	159	55.34%	4.85%	50.17%
Jericho	BananaFarm, EngineerMonkey, MonkeyAce	60	37	23	61.67%	0.82%	49.36%
Bonnie	DartMonkey, SniperMonkey, SpikeFactory	32	21	11	65.63%	0.44%	49.17%
Gwendolin	BananaFarm, IceMonkey, NinjaMonkey	29	19	10	65.52%	0.40%	48.22%
Churchill_Sentai	BananaFarm, EngineerMonkey, SuperMonkey	135	74	61	54.81%	1.84%	46.42%
Etienne	BananaFarm, BombShooter, SpikeFactory	58	34	24	58.62%	0.79%	45.95%
Jericho	BananaFarm, TackShooter, WizardMonkey	80	45	35	56.25%	1.09%	45.38%
Bonnie	DartMonkey, MonkeyVillage, SuperMonkey	38	23	15	60.53%	0.52%	44.98%
StrikerJones_Biker	HeliPilot, IceMonkey, MonkeyVillage	100	54	46	54.00%	1.36%	44.23%
StrikerJones	BananaFarm, BombShooter, MortarMonkey	33	20	13	60.61%	0.45%	43.93%
StrikerJones_Biker	BananaFarm, HeliPilot, IceMonkey	35	21	14	60.00%	0.48%	43.77%
Etienne_Bee	BananaFarm, BoomerangMonkey, NinjaMonkey	60	33	27	55.00%	0.82%	42.41%
Churchill_Sentai	BananaFarm, DartMonkey, SpikeFactory	42	24	18	57.14%	0.57%	42.18%
Churchill_Sentai	BananaFarm, IceMonkey, MonkeySub	113	58	55	51.33%	1.54%	42.11%
PatFusty_Snowman	BananaFarm, IceMonkey, NinjaMonkey	29	17	12	58.62%	0.40%	40.70%
Benjamin	DartlingGunner, MonkeyVillage, SuperMonkey	146	71	75	48.63%	1.99%	40.52%
Quincy	BananaFarm, TackShooter, WizardMonkey	103	51	52	49.51%	1.40%	39.86%
Ezili	BananaFarm, BombShooter, WizardMonkey	51	27	24	52.94%	0.69%	39.24%
StrikerJones_Biker	BananaFarm, EngineerMonkey, MonkeyAce	76	37	39	48.68%	1.04%	37.45%
Churchill_Sentai	BananaFarm, BombShooter, MonkeySub	38	20	18	52.63%	0.52%	36.76%
Churchill	BananaFarm, EngineerMonkey, SuperMonkey	30	16	14	53.33%	0.41%	35.48%
Bonnie	BananaFarm, SniperMonkey, WizardMonkey	35	18	17	51.43%	0.48%	34.87%
Etienne	BananaFarm, BombShooter, DartlingGunner	29	15	14	51.72%	0.40%	33.54%
Obyn	Druid, MonkeySub, SpikeFactory	32	16	16	50.00%	0.44%	32.68%
Obyn	DartlingGunner, Druid, SpikeFactory	23	12	11	52.17%	0.31%	31.76%
Etienne	BananaFarm, SniperMonkey, TackShooter	26	13	13	50.00%	0.35%	30.78%
Etienne	EngineerMonkey, TackShooter, WizardMonkey	20	10	10	50.00%	0.27%	28.09%
Quincy_Cyber	BananaFarm, BoomerangMonkey, MortarMonkey	20	10	10	50.00%	0.27%	28.09%
Etienne_Bee	BananaFarm, BoomerangMonkey, EngineerMonkey	29	13	16	44.83%	0.40%	26.73%
Ezili	BananaFarm, NinjaMonkey, WizardMonkey	27	12	15	44.44%	0.37%	25.70%
Gwendolin_Science	GlueGunner, MonkeyVillage, TackShooter	79	28	51	35.44%	1.08%	24.89%
Obyn_Ocean	Alchemist, BananaFarm, NinjaMonkey	71	25	46	35.21%	0.97%	24.10%
Quincy_Cyber	BananaFarm, BoomerangMonkey, WizardMonkey	23	10	13	43.48%	0.31%	23.22%
Churchill	BananaFarm, IceMonkey, MonkeySub	57	20	37	35.09%	0.78%	22.70%
Quincy_Cyber	BananaFarm, EngineerMonkey, MonkeyAce	26	10	16	38.46%	0.35%	19.76%
Jericho	BananaFarm, IceMonkey, MonkeySub	46	14	32	30.43%	0.63%	17.14%

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)

44 rows

Advanced export