season_26_matches: off_tide_hero

41 rows

descending

Hero	Loadout	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
PatFusty_Snowman	BananaFarm, DartlingGunner, IceMonkey	117	93	24	79.49%	1.72%	72.17%
Bonnie	BoomerangMonkey, MortarMonkey, SpikeFactory	40	29	11	72.50%	0.59%	58.66%
PatFusty_Snowman	IceMonkey, MonkeyVillage, TackShooter	48	34	14	70.83%	0.71%	57.97%
Etienne	BananaFarm, BoomerangMonkey, SpikeFactory	106	68	38	64.15%	1.56%	55.02%
Benjamin	DartlingGunner, MonkeyVillage, SuperMonkey	62	41	21	66.13%	0.91%	54.35%
Etienne	BananaFarm, DartMonkey, GlueGunner	228	138	90	60.53%	3.35%	54.18%
Obyn	BananaFarm, Druid, MortarMonkey	48	32	16	66.67%	0.71%	53.33%
Quincy	BananaFarm, BoomerangMonkey, MortarMonkey	31	21	10	67.74%	0.46%	51.29%
Etienne_Bee	BananaFarm, BoomerangMonkey, SpikeFactory	52	33	19	63.46%	0.76%	50.37%
PatFusty_Snowman	BananaFarm, IceMonkey, TackShooter	35	23	12	65.71%	0.51%	49.99%
Jericho	BananaFarm, TackShooter, WizardMonkey	84	50	34	59.52%	1.23%	49.03%
Adora	BananaFarm, DartMonkey, MortarMonkey	67	39	28	58.21%	0.98%	46.40%
Etienne_Bee	BananaFarm, BombShooter, SpikeFactory	127	69	58	54.33%	1.87%	45.67%
Gwendolin_Science	GlueGunner, MonkeyVillage, TackShooter	171	90	81	52.63%	2.51%	45.15%
Gwendolin_Science	GlueGunner, HeliPilot, MonkeyVillage	199	101	98	50.75%	2.92%	43.81%
Obyn_Ocean	Alchemist, HeliPilot, NinjaMonkey	47	27	20	57.45%	0.69%	43.31%
Ezili	BananaFarm, BombShooter, WizardMonkey	95	50	45	52.63%	1.40%	42.59%
Jericho	BananaFarm, BoomerangMonkey, MortarMonkey	32	19	13	59.38%	0.47%	42.36%
Etienne	MonkeyVillage, SniperMonkey, TackShooter	47	26	21	55.32%	0.69%	41.11%
Etienne	BananaFarm, BombShooter, SpikeFactory	118	59	59	50.00%	1.73%	40.98%
Jericho_StarCaptain	BananaFarm, DartMonkey, MortarMonkey	39	22	17	56.41%	0.57%	40.85%
Jericho	BananaFarm, MortarMonkey, TackShooter	31	18	13	58.06%	0.46%	40.69%
Bonnie	SpikeFactory, TackShooter, WizardMonkey	30	17	13	56.67%	0.44%	38.93%
PatFusty_Snowman	HeliPilot, IceMonkey, SuperMonkey	24	13	11	54.17%	0.35%	34.23%
Obyn	Alchemist, Druid, MonkeyVillage	57	26	31	45.61%	0.84%	32.68%
Bonnie	Alchemist, DartlingGunner, SpikeFactory	21	11	10	52.38%	0.31%	31.02%
Jericho_StarCaptain	BananaFarm, MortarMonkey, TackShooter	31	15	16	48.39%	0.46%	30.79%
Obyn_Ocean	Alchemist, BananaFarm, NinjaMonkey	55	24	31	43.64%	0.81%	30.53%
Jericho	BananaFarm, EngineerMonkey, MonkeyAce	22	11	11	50.00%	0.32%	29.11%
Jericho_Highwayman	BananaFarm, TackShooter, WizardMonkey	36	16	20	44.44%	0.53%	28.21%
Etienne	BananaFarm, GlueGunner, TackShooter	59	24	35	40.68%	0.87%	28.14%
Gwendolin_Science	GlueGunner, MonkeyVillage, NinjaMonkey	60	24	36	40.00%	0.88%	27.60%
Etienne	BananaFarm, SniperMonkey, TackShooter	37	16	21	43.24%	0.54%	27.28%
Quincy_Cyber	BananaFarm, TackShooter, WizardMonkey	35	15	20	42.86%	0.51%	26.46%
Jericho	BananaFarm, DartMonkey, MortarMonkey	28	12	16	42.86%	0.41%	24.53%
Etienne	EngineerMonkey, TackShooter, WizardMonkey	35	14	21	40.00%	0.51%	23.77%
Ezili	BananaFarm, TackShooter, WizardMonkey	26	11	15	42.31%	0.38%	23.32%
Obyn	BananaFarm, Druid, MonkeySub	44	16	28	36.36%	0.65%	22.15%
Quincy	BananaFarm, TackShooter, WizardMonkey	28	11	17	39.29%	0.41%	21.20%
Gwendolin_Science	Alchemist, GlueGunner, NinjaMonkey	26	10	16	38.46%	0.38%	19.76%
Gwendolin_Science	DartMonkey, GlueGunner, MonkeyVillage	28	10	18	35.71%	0.41%	17.97%

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)

41 rows

Advanced export