season_31_matches: star_hero

44 rows

descending

Hero	Loadout	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Etienne_Bee	BananaFarm, IceMonkey, MonkeySub	96	76	20	79.17%	1.23%	71.04%
StrikerJones_Biker	BananaFarm, EngineerMonkey, MonkeyAce	43	33	10	76.74%	0.55%	64.12%
Quincy_Cyber	BananaFarm, TackShooter, WizardMonkey	295	194	101	65.76%	3.77%	60.35%
PatFusty_Snowman	BananaFarm, DartlingGunner, IceMonkey	184	121	63	65.76%	2.35%	58.90%
Jericho	BananaFarm, BombShooter, MonkeySub	88	60	28	68.18%	1.12%	58.45%
Benjamin	BananaFarm, DartlingGunner, NinjaMonkey	89	60	29	67.42%	1.14%	57.68%
Etienne_Bee	BananaFarm, BoomerangMonkey, NinjaMonkey	52	35	17	67.31%	0.66%	54.56%
Jericho	BananaFarm, TackShooter, WizardMonkey	136	84	52	61.76%	1.74%	53.60%
Etienne	EngineerMonkey, TackShooter, WizardMonkey	32	22	10	68.75%	0.41%	52.69%
Benjamin	DartlingGunner, MonkeyVillage, SuperMonkey	196	114	82	58.16%	2.50%	51.26%
Jericho_Highwayman	BananaFarm, TackShooter, WizardMonkey	54	34	20	62.96%	0.69%	50.08%
Jericho	BananaFarm, IceMonkey, MonkeySub	275	149	126	54.18%	3.51%	48.29%
Gwendolin_Science	GlueGunner, MonkeyVillage, TackShooter	259	135	124	52.12%	3.31%	46.04%
Churchill_Sentai	BananaFarm, IceMonkey, MonkeySub	163	87	76	53.37%	2.08%	45.72%
Obyn	DartlingGunner, Druid, SpikeFactory	45	27	18	60.00%	0.57%	45.69%
Quincy	BananaFarm, TackShooter, WizardMonkey	151	81	70	53.64%	1.93%	45.69%
StrikerJones_Biker	BananaFarm, HeliPilot, IceMonkey	74	42	32	56.76%	0.95%	45.47%
Ezili	BananaFarm, NinjaMonkey, WizardMonkey	33	20	13	60.61%	0.42%	43.93%
Benjamin	BananaFarm, DartlingGunner, SuperMonkey	51	29	22	56.86%	0.65%	43.27%
Jericho	BananaFarm, EngineerMonkey, MonkeyAce	33	19	14	57.58%	0.42%	40.71%
StrikerJones_Biker	HeliPilot, IceMonkey, MonkeyVillage	141	69	72	48.94%	1.80%	40.68%
Obyn	BananaFarm, Druid, MonkeySub	145	69	76	47.59%	1.85%	39.46%
Etienne	BananaFarm, BombShooter, SpikeFactory	34	19	15	55.88%	0.43%	39.19%
Etienne	BananaFarm, SniperMonkey, TackShooter	45	24	21	53.33%	0.57%	38.76%
Adora	MonkeyVillage, SniperMonkey, SuperMonkey	50	26	24	52.00%	0.64%	38.15%
Etienne_Bee	BananaFarm, BombShooter, DartlingGunner	27	15	12	55.56%	0.34%	36.81%
Bonnie	DartMonkey, MonkeyVillage, SuperMonkey	30	16	14	53.33%	0.38%	35.48%
Etienne_Bee	BananaFarm, BoomerangMonkey, EngineerMonkey	24	13	11	54.17%	0.31%	34.23%
Churchill	BananaFarm, IceMonkey, MonkeySub	98	43	55	43.88%	1.25%	34.05%
Churchill_Sentai	BananaFarm, EngineerMonkey, MonkeyAce	22	12	10	54.55%	0.28%	33.74%
Etienne	BananaFarm, TackShooter, WizardMonkey	22	12	10	54.55%	0.28%	33.74%
Ezili	BananaFarm, BombShooter, WizardMonkey	22	12	10	54.55%	0.28%	33.74%
PatFusty	MonkeySub, MonkeyVillage, SuperMonkey	96	41	55	42.71%	1.23%	32.81%
Bonnie	BananaFarm, SniperMonkey, WizardMonkey	37	18	19	48.65%	0.47%	32.54%
Etienne_Bee	BananaFarm, BoomerangMonkey, SpikeFactory	23	12	11	52.17%	0.29%	31.76%
Churchill_Sentai	BananaFarm, EngineerMonkey, SuperMonkey	59	26	33	44.07%	0.75%	31.40%
Churchill_Sentai	BananaFarm, BombShooter, MonkeySub	20	10	10	50.00%	0.26%	28.09%
Gwendolin_Science	GlueGunner, HeliPilot, MonkeyVillage	20	10	10	50.00%	0.26%	28.09%
Bonnie	DartMonkey, SniperMonkey, SpikeFactory	29	13	16	44.83%	0.37%	26.73%
Etienne_Bee	BananaFarm, BombShooter, SpikeFactory	28	12	16	42.86%	0.36%	24.53%
Quincy	BananaFarm, IceMonkey, MonkeySub	33	13	20	39.39%	0.42%	22.72%
StrikerJones	BananaFarm, BombShooter, MonkeySub	27	11	16	40.74%	0.34%	22.21%
Bonnie	Alchemist, MonkeyBuccaneer, SpikeFactory	29	11	18	37.93%	0.37%	20.27%
Gwendolin	GlueGunner, MonkeyVillage, TackShooter	34	11	23	32.35%	0.43%	16.63%

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