s24+_matches: off_tide_hero_loadouts: 288 rows

288 rows

descending

Hero	Loadout	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Quincy	BananaFarm, BoomerangMonkey, MortarMonkey	458	356	102	77.73%	0.89%	73.92%
Etienne_Bee	BananaFarm, MortarMonkey, TackShooter	94	74	20	78.72%	0.18%	70.45%
Jericho	BananaFarm, DartMonkey, WizardMonkey	52	42	10	80.77%	0.10%	70.06%
Etienne_Bee	BananaFarm, EngineerMonkey, MonkeyAce	350	257	93	73.43%	0.68%	68.80%
PatFusty_Snowman	BananaFarm, DartMonkey, IceMonkey	49	39	10	79.59%	0.10%	68.31%
PatFusty_Snowman	BananaFarm, DartlingGunner, IceMonkey	1054	724	330	68.69%	2.06%	65.89%
Obyn	BananaFarm, Druid, MortarMonkey	227	161	66	70.93%	0.44%	65.02%
Benjamin_DJ	DartlingGunner, MonkeyVillage, SuperMonkey	72	53	19	73.61%	0.14%	63.43%
Etienne_Bee	BombShooter, DartMonkey, GlueGunner	103	74	29	71.84%	0.20%	63.16%
Quincy_Cyber	BananaFarm, EngineerMonkey, WizardMonkey	45	34	11	75.56%	0.09%	63.00%
Quincy_Cyber	BananaFarm, BoomerangMonkey, NinjaMonkey	50	37	13	74.00%	0.10%	61.84%
Etienne	BananaFarm, BombShooter, DartMonkey	78	56	22	71.79%	0.15%	61.81%
Etienne_Bee	BananaFarm, BombShooter, TackShooter	72	51	21	70.83%	0.14%	60.33%
Etienne_Bee	BananaFarm, BoomerangMonkey, IceMonkey	187	125	62	66.84%	0.36%	60.10%
Benjamin	BananaFarm, TackShooter, WizardMonkey	106	73	33	68.87%	0.21%	60.05%
Quincy_Cyber	BananaFarm, IceMonkey, WizardMonkey	87	60	27	68.97%	0.17%	59.24%
PatFusty_Snowman	IceMonkey, MonkeyVillage, SuperMonkey	43	31	12	72.09%	0.08%	58.69%
Quincy_Cyber	BananaFarm, EngineerMonkey, MonkeyAce	43	31	12	72.09%	0.08%	58.69%
Adora	BananaFarm, DartMonkey, MortarMonkey	379	240	139	63.32%	0.74%	58.47%
Benjamin	BananaFarm, DartlingGunner, NinjaMonkey	187	122	65	65.24%	0.36%	58.42%
Obyn	DartlingGunner, Druid, SpikeFactory	93	63	30	67.74%	0.18%	58.24%
Benjamin	DartlingGunner, MonkeyVillage, SuperMonkey	483	302	181	62.53%	0.94%	58.21%
Jericho_Highwayman	BananaFarm, TackShooter, WizardMonkey	582	361	221	62.03%	1.14%	58.08%
Etienne	BananaFarm, BoomerangMonkey, SpikeFactory	657	404	253	61.49%	1.28%	57.77%
Quincy	BananaFarm, BombShooter, MonkeySub	59	41	18	69.49%	0.12%	57.74%
Adora_Fateweaver	BananaFarm, DartMonkey, MortarMonkey	77	52	25	67.53%	0.15%	57.07%
PatFusty_Snowman	DartMonkey, IceMonkey, MonkeyVillage	111	73	38	65.77%	0.22%	56.94%
Etienne_Bee	BananaFarm, BoomerangMonkey, MonkeyAce	89	59	30	66.29%	0.17%	56.47%
Etienne_Bee	BananaFarm, BoomerangMonkey, NinjaMonkey	852	504	348	59.15%	1.66%	55.85%
Etienne_Bee	BananaFarm, BoomerangMonkey, SpikeFactory	815	482	333	59.14%	1.59%	55.77%
Jericho_StarCaptain	BananaFarm, TackShooter, WizardMonkey	313	191	122	61.02%	0.61%	55.62%
Ezili	BananaFarm, BombShooter, WizardMonkey	698	413	285	59.17%	1.36%	55.52%
Quincy_Cyber	BananaFarm, TackShooter, WizardMonkey	1295	753	542	58.15%	2.53%	55.46%
PatFusty_Snowman	BananaFarm, IceMonkey, NinjaMonkey	157	98	59	62.42%	0.31%	54.84%
Etienne	BananaFarm, DartMonkey, GlueGunner	1082	624	458	57.67%	2.11%	54.73%
Jericho	BananaFarm, MortarMonkey, TackShooter	490	286	204	58.37%	0.96%	54.00%
Adora	BananaFarm, MortarMonkey, TackShooter	46	31	15	67.39%	0.09%	53.84%
Bonnie	BananaFarm, TackShooter, WizardMonkey	86	55	31	63.95%	0.17%	53.81%
Ezili_SmudgeCat	BananaFarm, BoomerangMonkey, NinjaMonkey	53	35	18	66.04%	0.10%	53.29%
PatFusty_Snowman	BananaFarm, IceMonkey, TackShooter	177	106	71	59.89%	0.35%	52.67%
Adora	Alchemist, DartlingGunner, SuperMonkey	62	40	22	64.52%	0.12%	52.61%
PatFusty_Snowman	IceMonkey, MonkeyVillage, TackShooter	137	83	54	60.58%	0.27%	52.40%
Quincy_Cyber	BananaFarm, DartMonkey, WizardMonkey	49	32	17	65.31%	0.10%	51.98%
Etienne_Bee	BananaFarm, BoomerangMonkey, EngineerMonkey	325	186	139	57.23%	0.63%	51.85%
PatFusty_Snowman	Alchemist, IceMonkey, NinjaMonkey	56	36	20	64.29%	0.11%	51.74%
Adora_Fateweaver	BananaFarm, TackShooter, WizardMonkey	58	37	21	63.79%	0.11%	51.42%
Quincy	BananaFarm, DartMonkey, MonkeySub	36	24	12	66.67%	0.07%	51.27%
Bonnie	DartlingGunner, SpikeFactory, SuperMonkey	95	58	37	61.05%	0.19%	51.25%
Jericho	BananaFarm, BoomerangMonkey, MortarMonkey	74	46	28	62.16%	0.14%	51.11%
Jericho	BananaFarm, TackShooter, WizardMonkey	968	525	443	54.24%	1.89%	51.10%

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)

288 rows

Advanced export