s24+_matches: neo_highway_hero

57 rows

descending

Hero	Loadout	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Quincy	BananaFarm, BoomerangMonkey, MortarMonkey	218	174	44	79.82%	1.66%	74.49%
Benjamin	DartlingGunner, MonkeyVillage, SuperMonkey	208	145	63	69.71%	1.58%	63.47%
Churchill	BananaFarm, DartMonkey, SpikeFactory	643	425	218	66.10%	4.89%	62.44%
Quincy_Cyber	BananaFarm, DartMonkey, SpikeFactory	109	77	32	70.64%	0.83%	62.09%
Churchill_Sentai	BananaFarm, DartMonkey, SpikeFactory	1159	741	418	63.93%	8.82%	61.17%
Churchill_Sentai	BananaFarm, GlueGunner, SpikeFactory	700	423	277	60.43%	5.32%	56.81%
Benjamin	BananaFarm, DartlingGunner, NinjaMonkey	259	161	98	62.16%	1.97%	56.26%
Churchill_Sentai	BananaFarm, Druid, MonkeySub	34	24	10	70.59%	0.26%	55.27%
Etienne_Bee	BananaFarm, BoomerangMonkey, SpikeFactory	65	43	22	66.15%	0.49%	54.65%
Churchill_Sentai	BananaFarm, DartlingGunner, GlueGunner	41	28	13	68.29%	0.31%	54.05%
Churchill_Sentai	BananaFarm, DartMonkey, SniperMonkey	63	41	22	65.08%	0.48%	53.31%
Churchill_Sentai	BananaFarm, SniperMonkey, SpikeFactory	30	20	10	66.67%	0.23%	49.80%
Etienne	BananaFarm, DartMonkey, SpikeFactory	65	40	25	61.54%	0.49%	49.71%
Quincy	BananaFarm, DartMonkey, SpikeFactory	67	41	26	61.19%	0.51%	49.53%
Bonnie	DartMonkey, MonkeySub, SpikeFactory	77	46	31	59.74%	0.59%	48.79%
Bonnie	DartMonkey, MonkeyVillage, SuperMonkey	34	22	12	64.71%	0.26%	48.64%
Bonnie	Alchemist, DartlingGunner, SpikeFactory	603	315	288	52.24%	4.59%	48.25%
Churchill_Sentai	BananaFarm, EngineerMonkey, MonkeyAce	38	24	14	63.16%	0.29%	47.82%
PatFusty_Snowman	HeliPilot, IceMonkey, NinjaMonkey	61	36	25	59.02%	0.46%	46.67%
Churchill	BananaFarm, DartMonkey, MortarMonkey	112	62	50	55.36%	0.85%	46.15%
Churchill	BananaFarm, GlueGunner, SpikeFactory	242	123	119	50.83%	1.84%	44.53%
Adora	Alchemist, DartlingGunner, SuperMonkey	37	22	15	59.46%	0.28%	43.64%
Etienne	BananaFarm, BoomerangMonkey, SpikeFactory	66	36	30	54.55%	0.50%	42.53%
Bonnie	HeliPilot, IceMonkey, SuperMonkey	42	24	18	57.14%	0.32%	42.18%
Churchill	BananaFarm, BoomerangMonkey, MortarMonkey	29	17	12	58.62%	0.22%	40.70%
Etienne	BananaFarm, DartMonkey, SniperMonkey	28	16	12	57.14%	0.21%	38.81%
Etienne	DartMonkey, SniperMonkey, SpikeFactory	26	15	11	57.69%	0.20%	38.70%
Quincy_Cyber	Alchemist, DartlingGunner, SpikeFactory	26	15	11	57.69%	0.20%	38.70%
Etienne	BananaFarm, DartMonkey, GlueGunner	117	55	62	47.01%	0.89%	37.96%
Benjamin	BananaFarm, DartlingGunner, SuperMonkey	46	24	22	52.17%	0.35%	37.74%
Churchill_Sentai	BananaFarm, DartMonkey, MortarMonkey	33	18	15	54.55%	0.25%	37.56%
Churchill_Sentai	BananaFarm, DartlingGunner, SpikeFactory	76	37	39	48.68%	0.58%	37.45%
Churchill	BananaFarm, EngineerMonkey, SpikeFactory	43	22	21	51.16%	0.33%	36.22%
Adora	BananaFarm, DartMonkey, SpikeFactory	66	31	35	46.97%	0.50%	34.93%
Churchill_Sentai	BananaFarm, IceMonkey, MonkeySub	47	23	24	48.94%	0.36%	34.64%
Churchill	BananaFarm, SniperMonkey, SpikeFactory	24	13	11	54.17%	0.18%	34.23%
Bonnie	BananaFarm, SniperMonkey, WizardMonkey	27	14	13	51.85%	0.21%	33.00%
Churchill	BananaFarm, DartMonkey, SniperMonkey	42	20	22	47.62%	0.32%	32.51%
Churchill_Sentai	BananaFarm, EngineerMonkey, SpikeFactory	58	26	32	44.83%	0.44%	32.03%
Churchill	Alchemist, DartlingGunner, SpikeFactory	41	19	22	46.34%	0.31%	31.08%
Quincy	Alchemist, DartlingGunner, SpikeFactory	41	19	22	46.34%	0.31%	31.08%
Churchill	DartMonkey, SniperMonkey, SpikeFactory	32	15	17	46.88%	0.24%	29.58%
Churchill_Sentai	Alchemist, DartlingGunner, SpikeFactory	43	19	24	44.19%	0.33%	29.34%
Churchill	BananaFarm, BoomerangMonkey, SpikeFactory	30	14	16	46.67%	0.23%	28.81%
Churchill	BananaFarm, DartlingGunner, SpikeFactory	44	19	25	43.18%	0.33%	28.55%
Quincy_Cyber	BananaFarm, BoomerangMonkey, WizardMonkey	20	10	10	50.00%	0.15%	28.09%
Etienne_Bee	BananaFarm, DartMonkey, SpikeFactory	26	12	14	46.15%	0.20%	26.99%
Adora_Fateweaver	BananaFarm, DartMonkey, SpikeFactory	24	11	13	45.83%	0.18%	25.90%
Churchill_Sentai	BananaFarm, BoomerangMonkey, MortarMonkey	37	15	22	40.54%	0.28%	24.72%
Bonnie	SniperMonkey, SpikeFactory, WizardMonkey	22	10	12	45.45%	0.17%	24.65%

Advanced export

JSON shape: default, array, newline-delimited

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

neo_highway_hero_loadouts (view)

57 rows

Advanced export