s24+_matches: mayan_map_01_hero

127 rows

descending

Hero	Loadout	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Churchill	Alchemist, NinjaMonkey, SniperMonkey	46	36	10	78.26%	0.20%	66.34%
Etienne_Bee	BananaFarm, BoomerangMonkey, SpikeFactory	60	45	15	75.00%	0.26%	64.04%
Gwendolin_Science	GlueGunner, MonkeyVillage, TackShooter	1472	921	551	62.57%	6.30%	60.10%
Quincy_Cyber	BananaFarm, TackShooter, WizardMonkey	206	137	69	66.50%	0.88%	60.06%
Jericho	BananaFarm, TackShooter, WizardMonkey	387	246	141	63.57%	1.66%	58.77%
Jericho	BananaFarm, MortarMonkey, TackShooter	66	45	21	68.18%	0.28%	56.94%
PatFusty_Snowman	IceMonkey, MonkeyVillage, NinjaMonkey	38	27	11	71.05%	0.16%	56.63%
Adora	IceMonkey, SniperMonkey, SuperMonkey	57	39	18	68.42%	0.24%	56.35%
Benjamin	BananaFarm, DartlingGunner, NinjaMonkey	43	30	13	69.77%	0.18%	56.04%
Etienne_Bee	GlueGunner, MonkeyVillage, TackShooter	88	58	30	65.91%	0.38%	56.01%
Etienne	BananaFarm, GlueGunner, TackShooter	178	112	66	62.92%	0.76%	55.83%
Gwendolin_Science	GlueGunner, HeliPilot, MonkeyVillage	266	163	103	61.28%	1.14%	55.42%
PatFusty_Snowman	BananaFarm, IceMonkey, TackShooter	34	24	10	70.59%	0.15%	55.27%
Quincy	BananaFarm, SniperMonkey, TackShooter	65	43	22	66.15%	0.28%	54.65%
Etienne_Bee	DartMonkey, GlueGunner, MonkeyAce	49	33	16	67.35%	0.21%	54.22%
Jericho_Highwayman	BananaFarm, TackShooter, WizardMonkey	82	52	30	63.41%	0.35%	52.99%
PatFusty_Snowman	IceMonkey, MonkeyVillage, TackShooter	57	37	20	64.91%	0.24%	52.52%
Quincy	BananaFarm, TackShooter, WizardMonkey	398	226	172	56.78%	1.70%	51.92%
Bonnie	SniperMonkey, SpikeFactory, WizardMonkey	61	39	22	63.93%	0.26%	51.88%
Ezili	BananaFarm, BombShooter, WizardMonkey	149	89	60	59.73%	0.64%	51.86%
PatFusty_Snowman	BananaFarm, DartlingGunner, IceMonkey	77	48	29	62.34%	0.33%	51.51%
Etienne	BananaFarm, SniperMonkey, TackShooter	98	59	39	60.20%	0.42%	50.51%
Etienne_Bee	BananaFarm, BoomerangMonkey, SuperMonkey	42	27	15	64.29%	0.18%	49.79%
PatFusty	GlueGunner, MonkeyVillage, TackShooter	73	44	29	60.27%	0.31%	49.05%
Etienne_Bee	BananaFarm, BoomerangMonkey, NinjaMonkey	101	59	42	58.42%	0.43%	48.80%
Jericho_StarCaptain	BananaFarm, TackShooter, WizardMonkey	101	59	42	58.42%	0.43%	48.80%
Churchill_Sentai	BananaFarm, IceMonkey, MonkeySub	41	26	15	63.41%	0.18%	48.67%
Bonnie	Druid, SniperMonkey, SuperMonkey	50	31	19	62.00%	0.21%	48.55%
Etienne	BoomerangMonkey, SniperMonkey, SuperMonkey	58	35	23	60.34%	0.25%	47.76%
Etienne	BananaFarm, BombShooter, SpikeFactory	103	59	44	57.28%	0.44%	47.73%
Gwendolin_Science	DartMonkey, GlueGunner, MonkeyVillage	92	53	39	57.61%	0.39%	47.51%
Bonnie	SniperMonkey, SuperMonkey, WizardMonkey	51	31	20	60.78%	0.22%	47.38%
Gwendolin	GlueGunner, MonkeyVillage, TackShooter	207	112	95	54.11%	0.89%	47.32%
Bonnie	SniperMonkey, SuperMonkey, TackShooter	66	39	27	59.09%	0.28%	47.23%
Gwendolin	BananaFarm, TackShooter, WizardMonkey	68	40	28	58.82%	0.29%	47.13%
Etienne	MonkeyVillage, SniperMonkey, TackShooter	78	45	33	57.69%	0.33%	46.73%
Quincy	BananaFarm, SniperMonkey, WizardMonkey	54	32	22	59.26%	0.23%	46.15%
Etienne	DartMonkey, GlueGunner, MonkeyVillage	30	19	11	63.33%	0.13%	46.09%
Bonnie	GlueGunner, MonkeyVillage, TackShooter	88	49	39	55.68%	0.38%	45.30%
Benjamin	DartlingGunner, MonkeyVillage, SuperMonkey	96	53	43	55.21%	0.41%	45.26%
Gwendolin	IceMonkey, MonkeyVillage, TackShooter	185	97	88	52.43%	0.79%	45.24%
Bonnie	DartlingGunner, SpikeFactory, SuperMonkey	55	32	23	58.18%	0.24%	45.15%
Bonnie	SpikeFactory, TackShooter, WizardMonkey	65	37	28	56.92%	0.28%	44.88%
Ezili	BananaFarm, NinjaMonkey, WizardMonkey	40	24	16	60.00%	0.17%	44.82%
Etienne	BananaFarm, SniperMonkey, WizardMonkey	35	21	14	60.00%	0.15%	43.77%
Etienne	BananaFarm, BoomerangMonkey, SniperMonkey	39	23	16	58.97%	0.17%	43.54%
Etienne	BananaFarm, DartMonkey, GlueGunner	75	41	34	54.67%	0.32%	43.40%
Etienne	BananaFarm, BombShooter, DartlingGunner	26	16	10	61.54%	0.11%	42.84%
Gwendolin_Science	Alchemist, GlueGunner, NinjaMonkey	99	52	47	52.53%	0.42%	42.69%
Bonnie	Alchemist, DartlingGunner, SpikeFactory	72	39	33	54.17%	0.31%	42.66%

Advanced export

JSON shape: default, array, newline-delimited

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

mayan_map_01_hero_loadouts (view)

127 rows

Advanced export