season_25_matches: off_tide_hero

36 rows

descending

Hero	Loadout	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Obyn	BananaFarm, Druid, MortarMonkey	84	66	18	78.57%	1.27%	69.80%
PatFusty_Snowman	DartMonkey, IceMonkey, MonkeyVillage	53	41	12	77.36%	0.80%	66.09%
Etienne	BananaFarm, BoomerangMonkey, SpikeFactory	71	52	19	73.24%	1.07%	62.94%
Adora	BananaFarm, DartMonkey, MortarMonkey	106	74	32	69.81%	1.60%	61.07%
Etienne_Bee	BananaFarm, BoomerangMonkey, SpikeFactory	46	32	14	69.57%	0.69%	56.27%
Etienne	BananaFarm, DartMonkey, GlueGunner	176	100	76	56.82%	2.66%	49.50%
Etienne	BananaFarm, BombShooter, SpikeFactory	120	69	51	57.50%	1.81%	48.66%
Ezili	BananaFarm, BombShooter, WizardMonkey	96	55	41	57.29%	1.45%	47.40%
Quincy_Cyber	BananaFarm, BombShooter, WizardMonkey	39	24	15	61.54%	0.59%	46.27%
Gwendolin_Science	DartMonkey, GlueGunner, MonkeyVillage	59	34	25	57.63%	0.89%	45.02%
Jericho	BananaFarm, TackShooter, WizardMonkey	52	30	22	57.69%	0.79%	44.26%
Obyn_Ocean	Alchemist, HeliPilot, NinjaMonkey	43	25	18	58.14%	0.65%	43.39%
Jericho_Highwayman	BananaFarm, TackShooter, WizardMonkey	36	21	15	58.33%	0.54%	42.23%
Gwendolin_Science	GlueGunner, MonkeyVillage, TackShooter	174	85	89	48.85%	2.63%	41.42%
Etienne	BananaFarm, BoomerangMonkey, SniperMonkey	39	22	17	56.41%	0.59%	40.85%
Quincy	BananaFarm, TackShooter, WizardMonkey	33	19	14	57.58%	0.50%	40.71%
Obyn	Alchemist, Druid, MonkeyVillage	54	29	25	53.70%	0.82%	40.40%
Gwendolin_Science	GlueGunner, MonkeyVillage, NinjaMonkey	202	93	109	46.04%	3.05%	39.17%
Bonnie	SpikeFactory, TackShooter, WizardMonkey	24	14	10	58.33%	0.36%	38.61%
Etienne	BananaFarm, BombShooter, DartMonkey	24	14	10	58.33%	0.36%	38.61%
Etienne_Bee	BananaFarm, BombShooter, SpikeFactory	86	39	47	45.35%	1.30%	34.83%
Etienne_Bee	BananaFarm, BombShooter, DartlingGunner	33	17	16	51.52%	0.50%	34.46%
Etienne	BananaFarm, GlueGunner, TackShooter	58	26	32	44.83%	0.88%	32.03%
Bonnie	BoomerangMonkey, MortarMonkey, SpikeFactory	43	20	23	46.51%	0.65%	31.60%
Jericho	BananaFarm, MortarMonkey, TackShooter	28	14	14	50.00%	0.42%	31.48%
Etienne	MonkeyVillage, SniperMonkey, TackShooter	33	16	17	48.48%	0.50%	31.43%
Bonnie	SniperMonkey, SpikeFactory, SuperMonkey	31	15	16	48.39%	0.47%	30.79%
Obyn	BananaFarm, Druid, MonkeySub	25	12	13	48.00%	0.38%	28.42%
Adora	Alchemist, DartlingGunner, SuperMonkey	23	11	12	47.83%	0.35%	27.41%
Etienne	EngineerMonkey, TackShooter, WizardMonkey	46	19	27	41.30%	0.69%	27.08%
Etienne	DartMonkey, GlueGunner, MonkeyVillage	24	11	13	45.83%	0.36%	25.90%
Obyn_Ocean	Alchemist, BananaFarm, NinjaMonkey	36	15	21	41.67%	0.54%	25.56%
Gwendolin_Science	GlueGunner, HeliPilot, MonkeyVillage	109	37	72	33.94%	1.65%	25.06%
Bonnie	SniperMonkey, SuperMonkey, WizardMonkey	24	10	14	41.67%	0.36%	21.94%
Etienne_Bee	DartMonkey, GlueGunner, MonkeyVillage	26	10	16	38.46%	0.39%	19.76%
Gwendolin_Science	Alchemist, GlueGunner, NinjaMonkey	38	11	27	28.95%	0.57%	14.53%

Advanced export

JSON shape: default, array, newline-delimited

CREATE VIEW off_tide_hero_loadouts AS 
WITH off_tide AS
    (SELECT *
    FROM matches
    WHERE map = 'off_tide')
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 off_tide) * 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 off_tide
                  UNION ALL
                  SELECT rHero                               AS Hero,
                         printf('%s, %s, %s', rt1, rt2, rt3) AS Loadout,
                         NOT playerLeftWin                   AS Wins
                  FROM off_tide)
            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;

off_tide_hero_loadouts (view)

36 rows

Advanced export