season_26_matches: sun_palace_hero

40 rows

descending

Hero	Loadout	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Jericho	BananaFarm, EngineerMonkey, MonkeyAce	342	232	110	67.84%	4.59%	62.89%
Obyn	BananaFarm, Druid, MortarMonkey	63	46	17	73.02%	0.85%	62.05%
Benjamin	DartlingGunner, MonkeyVillage, SuperMonkey	42	28	14	66.67%	0.56%	52.41%
Obyn_Ocean	Alchemist, HeliPilot, NinjaMonkey	58	37	21	63.79%	0.78%	51.42%
Etienne	BananaFarm, DartMonkey, GlueGunner	196	113	83	57.65%	2.63%	50.74%
PatFusty_Snowman	HeliPilot, IceMonkey, SuperMonkey	38	25	13	65.79%	0.51%	50.71%
Obyn	Alchemist, Druid, MonkeyVillage	52	33	19	63.46%	0.70%	50.37%
Gwendolin_Science	GlueGunner, HeliPilot, MonkeyVillage	325	181	144	55.69%	4.36%	50.29%
Etienne	DartMonkey, GlueGunner, MonkeyVillage	35	23	12	65.71%	0.47%	49.99%
Etienne	BananaFarm, BoomerangMonkey, SpikeFactory	59	36	23	61.02%	0.79%	48.57%
Adora	BananaFarm, DartMonkey, MortarMonkey	50	31	19	62.00%	0.67%	48.55%
Gwendolin_Science	GlueGunner, MonkeyVillage, TackShooter	144	81	63	56.25%	1.93%	48.15%
Gwendolin_Science	GlueGunner, MonkeyVillage, NinjaMonkey	216	115	101	53.24%	2.90%	46.59%
Jericho_Highwayman	BananaFarm, EngineerMonkey, MonkeyAce	59	34	25	57.63%	0.79%	45.02%
Gwendolin_Science	DartMonkey, GlueGunner, MonkeyVillage	73	39	34	53.42%	0.98%	41.98%
Etienne	BananaFarm, BombShooter, SpikeFactory	43	24	19	55.81%	0.58%	40.97%
Etienne_Bee	BananaFarm, BoomerangMonkey, SuperMonkey	37	21	16	56.76%	0.50%	40.79%
Jericho_Highwayman	BananaFarm, TackShooter, WizardMonkey	42	23	19	54.76%	0.56%	39.71%
Etienne	BananaFarm, EngineerMonkey, MonkeyAce	36	20	16	55.56%	0.48%	39.32%
Ezili	BananaFarm, BombShooter, WizardMonkey	93	45	48	48.39%	1.25%	38.23%
Obyn	BananaFarm, Druid, MonkeySub	83	40	43	48.19%	1.11%	37.44%
Bonnie	MonkeyAce, SniperMonkey, WizardMonkey	29	16	13	55.17%	0.39%	37.07%
Jericho_StarCaptain	BananaFarm, EngineerMonkey, MonkeyAce	40	21	19	52.50%	0.54%	37.02%
PatFusty_Snowman	BananaFarm, DartlingGunner, IceMonkey	25	14	11	56.00%	0.34%	36.54%
Churchill	BananaFarm, EngineerMonkey, SpikeFactory	23	13	10	56.52%	0.31%	36.26%
Etienne	MonkeyVillage, SniperMonkey, TackShooter	34	18	16	52.94%	0.46%	36.16%
Jericho	BananaFarm, TackShooter, WizardMonkey	67	32	35	47.76%	0.90%	35.80%
Quincy_Cyber	BananaFarm, TackShooter, WizardMonkey	24	13	11	54.17%	0.32%	34.23%
Etienne_Bee	BananaFarm, BombShooter, SpikeFactory	29	15	14	51.72%	0.39%	33.54%
Etienne	EngineerMonkey, TackShooter, WizardMonkey	34	17	17	50.00%	0.46%	33.19%
Bonnie	Druid, SniperMonkey, SuperMonkey	25	13	12	52.00%	0.34%	32.42%
Bonnie	GlueGunner, MonkeyVillage, TackShooter	30	15	15	50.00%	0.40%	32.11%
Churchill_Sentai	BananaFarm, EngineerMonkey, MonkeyAce	22	11	11	50.00%	0.30%	29.11%
Etienne_Bee	BananaFarm, DartMonkey, GlueGunner	30	14	16	46.67%	0.40%	28.81%
Churchill_Sentai	BananaFarm, EngineerMonkey, SuperMonkey	41	18	23	43.90%	0.55%	28.71%
Gwendolin_Science	Alchemist, GlueGunner, NinjaMonkey	42	17	25	40.48%	0.56%	25.63%
Obyn_Ocean	Alchemist, BananaFarm, NinjaMonkey	30	13	17	43.33%	0.40%	25.60%
Churchill	BananaFarm, EngineerMonkey, SuperMonkey	32	13	19	40.63%	0.43%	23.61%
Etienne	BananaFarm, SniperMonkey, TackShooter	36	13	23	36.11%	0.48%	20.42%
Etienne	BombShooter, DartlingGunner, MonkeyBuccaneer	26	10	16	38.46%	0.35%	19.76%

Advanced export

JSON shape: default, array, newline-delimited

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

sun_palace_hero_loadouts (view)

40 rows

Advanced export