s24+_matches: castle_ruins_hero

204 rows

descending

Hero	Loadout	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Quincy	BananaFarm, BoomerangMonkey, MortarMonkey	326	255	71	78.22%	0.97%	73.74%
Etienne_Bee	BananaFarm, EngineerMonkey, MonkeyAce	591	443	148	74.96%	1.75%	71.46%
Quincy_Cyber	BananaFarm, EngineerMonkey, MonkeyAce	117	85	32	72.65%	0.35%	64.57%
Jericho	BananaFarm, EngineerMonkey, MonkeyAce	883	594	289	67.27%	2.61%	64.18%
Quincy_Cyber	BananaFarm, EngineerMonkey, WizardMonkey	85	62	23	72.94%	0.25%	63.50%
Obyn	BananaFarm, Druid, MortarMonkey	143	101	42	70.63%	0.42%	63.16%
Benjamin_DJ	DartlingGunner, MonkeyVillage, SuperMonkey	66	48	18	72.73%	0.20%	61.98%
Adora	BananaFarm, MortarMonkey, TackShooter	71	51	20	71.83%	0.21%	61.37%
Benjamin	DartlingGunner, MonkeyVillage, SuperMonkey	419	274	145	65.39%	1.24%	60.84%
Quincy_Cyber	BananaFarm, TackShooter, WizardMonkey	559	361	198	64.58%	1.65%	60.61%
Ezili_SmudgeCat	BananaFarm, BoomerangMonkey, NinjaMonkey	53	38	15	71.70%	0.16%	59.57%
Quincy_Cyber	BananaFarm, MonkeySub, TackShooter	64	45	19	70.31%	0.19%	59.12%
Quincy	BananaFarm, BoomerangMonkey, MonkeySub	55	39	16	70.91%	0.16%	58.91%
PatFusty_Snowman	BananaFarm, DartlingGunner, IceMonkey	370	236	134	63.78%	1.10%	58.89%
Quincy_Cyber	BananaFarm, BoomerangMonkey, MortarMonkey	46	33	13	71.74%	0.14%	58.73%
Quincy	BoomerangMonkey, EngineerMonkey, NinjaMonkey	45	32	13	71.11%	0.13%	57.87%
Jericho_Highwayman	BananaFarm, EngineerMonkey, MonkeyAce	110	73	37	66.36%	0.33%	57.53%
Etienne	EngineerMonkey, TackShooter, WizardMonkey	159	102	57	64.15%	0.47%	56.70%
Adora_Fateweaver	BananaFarm, SniperMonkey, TackShooter	45	31	14	68.89%	0.13%	55.36%
Bonnie	BananaFarm, TackShooter, WizardMonkey	45	31	14	68.89%	0.13%	55.36%
StrikerJones	DartlingGunner, HeliPilot, MortarMonkey	42	29	13	69.05%	0.12%	55.07%
Jericho_StarCaptain	BananaFarm, MonkeySub, TackShooter	36	25	11	69.44%	0.11%	54.40%
Jericho_StarCaptain	BananaFarm, TackShooter, WizardMonkey	128	80	48	62.50%	0.38%	54.11%
Ezili	BananaFarm, BombShooter, WizardMonkey	266	159	107	59.77%	0.79%	53.88%
Etienne	BananaFarm, SniperMonkey, TackShooter	237	141	96	59.49%	0.70%	53.24%
Benjamin	BananaFarm, DartlingGunner, EngineerMonkey	35	24	11	68.57%	0.10%	53.19%
Bonnie	MonkeyAce, SniperMonkey, WizardMonkey	35	24	11	68.57%	0.10%	53.19%
Jericho	BananaFarm, DartMonkey, WizardMonkey	40	27	13	67.50%	0.12%	52.98%
Jericho	BananaFarm, TackShooter, WizardMonkey	501	286	215	57.09%	1.48%	52.75%
Gwendolin_Science	DartMonkey, GlueGunner, MonkeyVillage	219	127	92	57.99%	0.65%	51.45%
Jericho	BananaFarm, BoomerangMonkey, MortarMonkey	31	21	10	67.74%	0.09%	51.29%
Obyn	BananaFarm, Druid, MonkeySub	2002	1070	932	53.45%	5.93%	51.26%
Etienne_Bee	BananaFarm, BoomerangMonkey, NinjaMonkey	300	170	130	56.67%	0.89%	51.06%
Etienne	BananaFarm, DartMonkey, GlueGunner	476	264	212	55.46%	1.41%	51.00%
Adora	BananaFarm, DartMonkey, MortarMonkey	112	67	45	59.82%	0.33%	50.74%
Quincy	BananaFarm, TackShooter, WizardMonkey	562	307	255	54.63%	1.66%	50.51%
Obyn	DartlingGunner, Druid, SpikeFactory	128	75	53	58.59%	0.38%	50.06%
Gwendolin_Science	GlueGunner, HeliPilot, MonkeyVillage	476	258	218	54.20%	1.41%	49.73%
Benjamin	BananaFarm, DartlingGunner, NinjaMonkey	196	111	85	56.63%	0.58%	49.69%
Etienne	BananaFarm, BombShooter, DartMonkey	51	32	19	62.75%	0.15%	49.48%
Jericho	BananaFarm, Druid, MonkeySub	41	26	15	63.41%	0.12%	48.67%
Quincy	BananaFarm, EngineerMonkey, MonkeyAce	68	41	27	60.29%	0.20%	48.66%
Adora_Fateweaver	BananaFarm, TackShooter, WizardMonkey	50	31	19	62.00%	0.15%	48.55%
Quincy_Cyber	BananaFarm, BoomerangMonkey, WizardMonkey	83	49	34	59.04%	0.25%	48.46%
Quincy	BananaFarm, DartMonkey, MortarMonkey	29	19	10	65.52%	0.09%	48.22%
Quincy	BananaFarm, DartMonkey, MonkeySub	45	28	17	62.22%	0.13%	48.06%
Adora_Fateweaver	BananaFarm, EngineerMonkey, MonkeyAce	47	29	18	61.70%	0.14%	47.80%
Etienne	BananaFarm, BoomerangMonkey, SniperMonkey	128	72	56	56.25%	0.38%	47.66%
Quincy_Cyber	BananaFarm, MortarMonkey, TackShooter	75	44	31	58.67%	0.22%	47.52%
Bonnie	BananaFarm, SniperMonkey, WizardMonkey	64	38	26	59.38%	0.19%	47.34%

Advanced export

JSON shape: default, array, newline-delimited

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

castle_ruins_hero_loadouts (view)

204 rows

Advanced export