season_31_matches: sun_palace_hero

38 rows

descending

Hero	Loadout	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Etienne_Bee	BananaFarm, EngineerMonkey, MonkeyAce	194	146	48	75.26%	2.90%	69.19%
Benjamin	BananaFarm, BoomerangMonkey, NinjaMonkey	54	43	11	79.63%	0.81%	68.89%
Jericho	BananaFarm, EngineerMonkey, MonkeyAce	405	260	145	64.20%	6.06%	59.53%
Churchill_Sentai	BananaFarm, HeliPilot, IceMonkey	37	26	11	70.27%	0.55%	55.54%
Benjamin	DartlingGunner, MonkeyVillage, SuperMonkey	85	55	30	64.71%	1.27%	54.55%
Etienne_Bee	BananaFarm, BoomerangMonkey, EngineerMonkey	38	26	12	68.42%	0.57%	53.64%
Quincy_Cyber	BananaFarm, TackShooter, WizardMonkey	190	113	77	59.47%	2.84%	52.49%
StrikerJones_Biker	EngineerMonkey, MonkeyAce, MonkeyVillage	111	67	44	60.36%	1.66%	51.26%
StrikerJones_Biker	BananaFarm, EngineerMonkey, MonkeyAce	205	118	87	57.56%	3.07%	50.80%
Quincy_Cyber	BananaFarm, EngineerMonkey, MonkeyAce	65	39	26	60.00%	0.97%	48.09%
Churchill_Sentai	BananaFarm, EngineerMonkey, MonkeyAce	98	56	42	57.14%	1.47%	47.34%
Etienne_Bee	BananaFarm, BoomerangMonkey, NinjaMonkey	105	59	46	56.19%	1.57%	46.70%
Churchill_Sentai	BananaFarm, EngineerMonkey, SuperMonkey	96	54	42	56.25%	1.44%	46.33%
Adora	IceMonkey, SniperMonkey, SuperMonkey	32	20	12	62.50%	0.48%	45.73%
Jericho_Highwayman	BananaFarm, TackShooter, WizardMonkey	29	18	11	62.07%	0.43%	44.41%
PatFusty_Snowman	BananaFarm, DartlingGunner, IceMonkey	31	19	12	61.29%	0.46%	44.14%
Etienne	BananaFarm, SniperMonkey, TackShooter	41	24	17	58.54%	0.61%	43.46%
Quincy_Cyber	BananaFarm, BoomerangMonkey, WizardMonkey	27	16	11	59.26%	0.40%	40.73%
Obyn	DartlingGunner, Druid, SpikeFactory	33	19	14	57.58%	0.49%	40.71%
Etienne_Bee	BananaFarm, BoomerangMonkey, SpikeFactory	50	27	23	54.00%	0.75%	40.19%
Gwendolin_Science	GlueGunner, HeliPilot, MonkeyVillage	73	37	36	50.68%	1.09%	39.22%
Ezili	BananaFarm, NinjaMonkey, WizardMonkey	41	22	19	53.66%	0.61%	38.39%
Etienne	BananaFarm, BoomerangMonkey, SpikeFactory	39	21	18	53.85%	0.58%	38.20%
Churchill	BananaFarm, EngineerMonkey, MonkeyAce	77	38	39	49.35%	1.15%	38.18%
Quincy	BananaFarm, TackShooter, WizardMonkey	98	47	51	47.96%	1.47%	38.07%
Gwendolin_Science	GlueGunner, MonkeyVillage, TackShooter	107	50	57	46.73%	1.60%	37.28%
Churchill	BananaFarm, EngineerMonkey, SuperMonkey	41	21	20	51.22%	0.61%	35.92%
Etienne	EngineerMonkey, TackShooter, WizardMonkey	32	17	15	53.13%	0.48%	35.83%
Jericho	BananaFarm, TackShooter, WizardMonkey	57	27	30	47.37%	0.85%	34.41%
StrikerJones_Biker	GlueGunner, HeliPilot, MonkeyVillage	27	14	13	51.85%	0.40%	33.00%
StrikerJones_Biker	HeliPilot, IceMonkey, MonkeyVillage	93	40	53	43.01%	1.39%	32.95%
Quincy_Cyber	BananaFarm, EngineerMonkey, WizardMonkey	23	12	11	52.17%	0.34%	31.76%
Jericho_StarCaptain	BananaFarm, EngineerMonkey, MonkeyAce	21	11	10	52.38%	0.31%	31.02%
Gwendolin_Science	GlueGunner, MonkeyVillage, NinjaMonkey	36	17	19	47.22%	0.54%	30.91%
Etienne	BananaFarm, EngineerMonkey, MonkeyAce	25	11	14	44.00%	0.37%	24.54%
Bonnie	BananaFarm, SniperMonkey, WizardMonkey	23	10	13	43.48%	0.34%	23.22%
PatFusty_Snowman	IceMonkey, MonkeyVillage, NinjaMonkey	27	10	17	37.04%	0.40%	18.82%
Obyn	BananaFarm, Druid, MonkeySub	31	11	20	35.48%	0.46%	18.64%

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)

38 rows

Advanced export