season_26_matches: star_hero

53 rows

descending

Hero	Loadout	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Jericho	BananaFarm, EngineerMonkey, MonkeyAce	116	89	27	76.72%	1.31%	69.03%
PatFusty_Snowman	BananaFarm, IceMonkey, MonkeyBuccaneer	59	43	16	72.88%	0.67%	61.54%
Adora	BananaFarm, DartMonkey, MortarMonkey	46	33	13	71.74%	0.52%	58.73%
PatFusty_Snowman	IceMonkey, MonkeyVillage, TackShooter	76	52	24	68.42%	0.86%	57.97%
Jericho	BananaFarm, BombShooter, MonkeySub	110	73	37	66.36%	1.24%	57.53%
PatFusty_Snowman	DartlingGunner, IceMonkey, MonkeyVillage	92	60	32	65.22%	1.04%	55.48%
PatFusty_Snowman	HeliPilot, IceMonkey, SuperMonkey	78	51	27	65.38%	0.88%	54.83%
Gwendolin_Science	GlueGunner, MonkeyVillage, TackShooter	420	248	172	59.05%	4.75%	54.34%
PatFusty	DartMonkey, IceMonkey, MonkeyVillage	87	56	31	64.37%	0.98%	54.30%
Benjamin_DJ	GlueGunner, MonkeyVillage, TackShooter	59	39	20	66.10%	0.67%	54.02%
PatFusty_Snowman	BananaFarm, DartlingGunner, IceMonkey	168	103	65	61.31%	1.90%	53.94%
Adora	BananaFarm, IceMonkey, SuperMonkey	35	24	11	68.57%	0.40%	53.19%
Benjamin	DartlingGunner, MonkeyVillage, SuperMonkey	111	67	44	60.36%	1.26%	51.26%
Etienne	BananaFarm, DartMonkey, GlueGunner	104	63	41	60.58%	1.18%	51.18%
Bonnie	GlueGunner, MonkeyVillage, TackShooter	41	26	15	63.41%	0.46%	48.67%
Adora	BananaFarm, MonkeySub, SuperMonkey	29	19	10	65.52%	0.33%	48.22%
Obyn	BananaFarm, Druid, MonkeySub	260	140	120	53.85%	2.94%	47.79%
Quincy_Cyber	BananaFarm, TackShooter, WizardMonkey	31	20	11	64.52%	0.35%	47.67%
Bonnie	Alchemist, MonkeyBuccaneer, SpikeFactory	73	43	30	58.90%	0.83%	47.62%
Etienne_Bee	DartMonkey, DartlingGunner, GlueGunner	28	18	10	64.29%	0.32%	46.54%
Ezili	BananaFarm, BombShooter, WizardMonkey	70	40	30	57.14%	0.79%	45.55%
Bonnie	MonkeySub, SpikeFactory, TackShooter	36	22	14	61.11%	0.41%	45.19%
Etienne	BananaFarm, BombShooter, SpikeFactory	114	59	55	51.75%	1.29%	42.58%
Benjamin_DJ	DartlingGunner, MonkeyVillage, SuperMonkey	69	37	32	53.62%	0.78%	41.86%
Jericho_StarCaptain	BananaFarm, BombShooter, MonkeySub	35	20	15	57.14%	0.40%	40.75%
Etienne	BananaFarm, BoomerangMonkey, SniperMonkey	31	18	13	58.06%	0.35%	40.69%
Jericho	BananaFarm, TackShooter, WizardMonkey	80	41	39	51.25%	0.91%	40.30%
Benjamin	BananaFarm, DartlingGunner, SuperMonkey	61	32	29	52.46%	0.69%	39.93%
Gwendolin_Science	GlueGunner, HeliPilot, MonkeyVillage	229	106	123	46.29%	2.59%	39.83%
Gwendolin	GlueGunner, MonkeyVillage, TackShooter	60	31	29	51.67%	0.68%	39.02%
PatFusty_Snowman	BananaFarm, IceMonkey, TackShooter	30	17	13	56.67%	0.34%	38.93%
PatFusty_Snowman	BananaFarm, IceMonkey, NinjaMonkey	26	15	11	57.69%	0.29%	38.70%
Obyn_Ocean	Alchemist, HeliPilot, NinjaMonkey	75	37	38	49.33%	0.85%	38.02%
Gwendolin	BananaFarm, IceMonkey, MonkeyBuccaneer	25	14	11	56.00%	0.28%	36.54%
Gwendolin_Science	GlueGunner, MonkeyVillage, NinjaMonkey	67	32	35	47.76%	0.76%	35.80%
Bonnie	Alchemist, DartlingGunner, SpikeFactory	24	13	11	54.17%	0.27%	34.23%
Bonnie	SpikeFactory, TackShooter, WizardMonkey	22	12	10	54.55%	0.25%	33.74%
Quincy	BananaFarm, SniperMonkey, WizardMonkey	27	14	13	51.85%	0.31%	33.00%
Etienne	BombShooter, DartlingGunner, MonkeyBuccaneer	37	17	20	45.95%	0.42%	29.89%
Etienne_Bee	BananaFarm, BombShooter, SpikeFactory	54	23	31	42.59%	0.61%	29.40%
Obyn	Alchemist, Druid, MonkeyVillage	36	16	20	44.44%	0.41%	28.21%
Bonnie	DartlingGunner, MonkeyVillage, SuperMonkey	20	10	10	50.00%	0.23%	28.09%
Benjamin	GlueGunner, MonkeyVillage, TackShooter	23	11	12	47.83%	0.26%	27.41%
Etienne	SniperMonkey, SuperMonkey, TackShooter	23	11	12	47.83%	0.26%	27.41%
Bonnie	MonkeyAce, SniperMonkey, WizardMonkey	29	13	16	44.83%	0.33%	26.73%
Gwendolin_Science	Alchemist, GlueGunner, NinjaMonkey	36	15	21	41.67%	0.41%	25.56%
Etienne	MonkeyVillage, SniperMonkey, TackShooter	49	19	30	38.78%	0.55%	25.13%
Obyn_Ocean	Alchemist, BananaFarm, NinjaMonkey	44	17	27	38.64%	0.50%	24.25%
Etienne	BananaFarm, GlueGunner, TackShooter	41	16	25	39.02%	0.46%	24.09%
Bonnie	DartMonkey, GlueGunner, WizardMonkey	23	10	13	43.48%	0.26%	23.22%

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)

53 rows

Advanced export