season_29_matches: star_hero

44 rows

descending

Hero	Loadout	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Jericho	BananaFarm, IceMonkey, MonkeySub	548	353	195	64.42%	6.77%	60.41%
PatFusty_Snowman	BananaFarm, DartlingGunner, IceMonkey	215	129	86	60.00%	2.65%	53.45%
Etienne_Bee	BananaFarm, BoomerangMonkey, EngineerMonkey	83	52	31	62.65%	1.02%	52.24%
Churchill_Sentai	BananaFarm, IceMonkey, MonkeySub	636	349	287	54.87%	7.85%	51.01%
Etienne_Bee	BananaFarm, BoomerangMonkey, NinjaMonkey	69	43	26	62.32%	0.85%	50.88%
Quincy_Cyber	BananaFarm, TackShooter, WizardMonkey	72	44	28	61.11%	0.89%	49.85%
Etienne_Bee	BananaFarm, GlueGunner, TackShooter	30	20	10	66.67%	0.37%	49.80%
Jericho	BananaFarm, TackShooter, WizardMonkey	39	25	14	64.10%	0.48%	49.05%
Ezili	BananaFarm, NinjaMonkey, WizardMonkey	107	62	45	57.94%	1.32%	48.59%
Obyn	BananaFarm, Druid, MonkeySub	338	182	156	53.85%	4.17%	48.53%
PatFusty_Snowman	DartlingGunner, IceMonkey, MonkeyVillage	39	24	15	61.54%	0.48%	46.27%
Jericho	BananaFarm, BombShooter, MonkeySub	112	62	50	55.36%	1.38%	46.15%
Churchill	BananaFarm, IceMonkey, MonkeySub	160	83	77	51.88%	1.98%	44.13%
Gwendolin_Science	GlueGunner, MonkeyVillage, TackShooter	245	123	122	50.20%	3.02%	43.94%
Etienne_Bee	BananaFarm, IceMonkey, MonkeySub	77	42	35	54.55%	0.95%	43.42%
Ezili	BananaFarm, BombShooter, WizardMonkey	26	16	10	61.54%	0.32%	42.84%
PatFusty_Snowman	IceMonkey, MonkeyVillage, NinjaMonkey	26	16	10	61.54%	0.32%	42.84%
Jericho_Highwayman	BananaFarm, IceMonkey, MonkeySub	70	38	32	54.29%	0.86%	42.62%
Etienne_Bee	DartMonkey, DartlingGunner, GlueGunner	30	18	12	60.00%	0.37%	42.47%
Gwendolin	BananaFarm, MonkeySub, TackShooter	30	18	12	60.00%	0.37%	42.47%
Jericho_Highwayman	BananaFarm, TackShooter, WizardMonkey	34	20	14	58.82%	0.42%	42.28%
Jericho	BananaFarm, EngineerMonkey, MonkeyAce	52	29	23	55.77%	0.64%	42.27%
Churchill_Sentai	BananaFarm, BombShooter, MonkeySub	115	59	56	51.30%	1.42%	42.17%
Quincy	BananaFarm, TackShooter, WizardMonkey	171	83	88	48.54%	2.11%	41.05%
Etienne	MonkeyVillage, SniperMonkey, TackShooter	31	18	13	58.06%	0.38%	40.69%
Benjamin	DartlingGunner, MonkeyVillage, SuperMonkey	72	37	35	51.39%	0.89%	39.84%
Etienne_Bee	BananaFarm, BombShooter, SpikeFactory	53	28	25	52.83%	0.65%	39.39%
Gwendolin_Science	GlueGunner, HeliPilot, MonkeyVillage	36	20	16	55.56%	0.44%	39.32%
Quincy	BananaFarm, MonkeySub, TackShooter	32	18	14	56.25%	0.40%	39.06%
Gwendolin	GlueGunner, MonkeyVillage, TackShooter	29	16	13	55.17%	0.36%	37.07%
Quincy_Cyber	BananaFarm, IceMonkey, MonkeySub	29	16	13	55.17%	0.36%	37.07%
Bonnie	Alchemist, MonkeyBuccaneer, SpikeFactory	25	14	11	56.00%	0.31%	36.54%
Etienne_Bee	BananaFarm, BoomerangMonkey, SpikeFactory	48	24	24	50.00%	0.59%	35.85%
Churchill	BananaFarm, BombShooter, MonkeySub	24	13	11	54.17%	0.30%	34.23%
Etienne	EngineerMonkey, TackShooter, WizardMonkey	38	19	19	50.00%	0.47%	34.10%
PatFusty_Snowman	IceMonkey, MonkeyVillage, TackShooter	38	19	19	50.00%	0.47%	34.10%
Obyn	DartlingGunner, Druid, SpikeFactory	22	12	10	54.55%	0.27%	33.74%
Etienne_Bee	GlueGunner, MonkeyVillage, TackShooter	30	15	15	50.00%	0.37%	32.11%
Benjamin	BananaFarm, DartlingGunner, SuperMonkey	40	19	21	47.50%	0.49%	32.02%
Obyn_Ocean	Alchemist, BananaFarm, NinjaMonkey	25	11	14	44.00%	0.31%	24.54%
Quincy_Cyber	BananaFarm, SniperMonkey, TackShooter	38	15	23	39.47%	0.47%	23.93%
Quincy	BananaFarm, SniperMonkey, WizardMonkey	29	12	17	41.38%	0.36%	23.45%
Etienne_Bee	BananaFarm, BombShooter, DartlingGunner	23	10	13	43.48%	0.28%	23.22%
Quincy	BananaFarm, BombShooter, MonkeySub	41	15	26	36.59%	0.51%	21.84%

Advanced export

JSON shape: default, array, newline-delimited

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

star_hero_loadouts (view)

44 rows

Advanced export