season_28_matches: sun_palace_hero

42 rows

descending

Hero	Loadout	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Etienne_Bee	BananaFarm, EngineerMonkey, MonkeyAce	185	134	51	72.43%	2.55%	65.99%
Jericho	BananaFarm, EngineerMonkey, MonkeyAce	569	381	188	66.96%	7.85%	63.09%
Jericho	BananaFarm, TackShooter, WizardMonkey	72	48	24	66.67%	0.99%	55.78%
Etienne	BananaFarm, EngineerMonkey, MonkeyAce	44	30	14	68.18%	0.61%	54.42%
Etienne_Bee	BananaFarm, BoomerangMonkey, EngineerMonkey	134	81	53	60.45%	1.85%	52.17%
Ezili	BananaFarm, BombShooter, WizardMonkey	83	51	32	61.45%	1.15%	50.97%
Gwendolin_Science	GlueGunner, HeliPilot, MonkeyVillage	389	211	178	54.24%	5.37%	49.29%
Jericho_Highwayman	BananaFarm, EngineerMonkey, MonkeyAce	32	21	11	65.63%	0.44%	49.17%
Churchill_Sentai	BananaFarm, EngineerMonkey, MonkeyAce	67	40	27	59.70%	0.92%	47.96%
Churchill_Sentai	BananaFarm, EngineerMonkey, SuperMonkey	33	21	12	63.64%	0.46%	47.22%
PatFusty_Snowman	HeliPilot, IceMonkey, SuperMonkey	44	27	17	61.36%	0.61%	46.98%
Benjamin	DartlingGunner, MonkeyVillage, SuperMonkey	28	18	10	64.29%	0.39%	46.54%
Gwendolin_Science	GlueGunner, MonkeyVillage, TackShooter	151	82	69	54.30%	2.08%	46.36%
Quincy	BananaFarm, TackShooter, WizardMonkey	107	58	49	54.21%	1.48%	44.77%
Gwendolin_Science	DartMonkey, GlueGunner, MonkeyVillage	51	29	22	56.86%	0.70%	43.27%
Etienne_Bee	BananaFarm, BoomerangMonkey, NinjaMonkey	144	74	70	51.39%	1.99%	43.23%
Etienne_Bee	BananaFarm, BoomerangMonkey, SpikeFactory	110	57	53	51.82%	1.52%	42.48%
Adora	BananaFarm, IceMonkey, SuperMonkey	33	19	14	57.58%	0.46%	40.71%
Etienne	BananaFarm, BoomerangMonkey, NinjaMonkey	33	19	14	57.58%	0.46%	40.71%
Etienne	BananaFarm, TackShooter, WizardMonkey	33	19	14	57.58%	0.46%	40.71%
PatFusty_Snowman	IceMonkey, MonkeyVillage, TackShooter	29	17	12	58.62%	0.40%	40.70%
Quincy	BananaFarm, EngineerMonkey, MonkeyAce	34	19	15	55.88%	0.47%	39.19%
Etienne	BananaFarm, BombShooter, SniperMonkey	33	18	15	54.55%	0.46%	37.56%
Churchill	BananaFarm, EngineerMonkey, MonkeyAce	139	63	76	45.32%	1.92%	37.05%
Etienne	BananaFarm, BoomerangMonkey, SpikeFactory	36	19	17	52.78%	0.50%	36.47%
Bonnie	GlueGunner, MonkeyVillage, TackShooter	23	13	10	56.52%	0.32%	36.26%
Obyn	BananaFarm, Druid, MonkeySub	90	41	49	45.56%	1.24%	35.27%
Etienne_Bee	BananaFarm, BoomerangMonkey, SuperMonkey	24	13	11	54.17%	0.33%	34.23%
Quincy	BananaFarm, IceMonkey, WizardMonkey	22	12	10	54.55%	0.30%	33.74%
Churchill	BananaFarm, EngineerMonkey, SuperMonkey	27	14	13	51.85%	0.37%	33.00%
Etienne_Bee	GlueGunner, MonkeyVillage, TackShooter	50	23	27	46.00%	0.69%	32.19%
Etienne_Bee	BananaFarm, BombShooter, SpikeFactory	28	14	14	50.00%	0.39%	31.48%
Churchill	BananaFarm, EngineerMonkey, SpikeFactory	21	11	10	52.38%	0.29%	31.02%
Obyn_Ocean	Alchemist, HeliPilot, NinjaMonkey	26	13	13	50.00%	0.36%	30.78%
Gwendolin_Science	GlueGunner, MonkeyVillage, NinjaMonkey	43	19	24	44.19%	0.59%	29.34%
PatFusty_Snowman	BananaFarm, IceMonkey, NinjaMonkey	26	12	14	46.15%	0.36%	26.99%
StrikerJones	BananaFarm, BombShooter, MortarMonkey	26	12	14	46.15%	0.36%	26.99%
PatFusty_Snowman	IceMonkey, MonkeyVillage, NinjaMonkey	45	18	27	40.00%	0.62%	25.69%
Jericho_Highwayman	BananaFarm, TackShooter, WizardMonkey	34	14	20	41.18%	0.47%	24.63%
Etienne	BananaFarm, DartMonkey, GlueGunner	50	18	32	36.00%	0.69%	22.70%
Gwendolin_Science	BananaFarm, GlueGunner, MonkeySub	28	11	17	39.29%	0.39%	21.20%
Obyn_Ocean	Alchemist, BananaFarm, NinjaMonkey	59	17	42	28.81%	0.81%	17.26%

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)

42 rows

Advanced export