s24+_matches: salmon_pool_hero

120 rows

descending

Hero	Loadout	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Quincy	BananaFarm, BombShooter, MortarMonkey	104	91	13	87.50%	0.37%	81.14%
Benjamin	DartlingGunner, MonkeyVillage, SuperMonkey	195	147	48	75.38%	0.70%	69.34%
Bonnie	Alchemist, DartMonkey, SpikeFactory	91	69	22	75.82%	0.33%	67.03%
Churchill_Sentai	BananaFarm, Druid, MonkeySub	72	55	17	76.39%	0.26%	66.58%
Quincy	BananaFarm, BombShooter, MonkeySub	184	133	51	72.28%	0.66%	65.82%
Churchill_Sentai	BananaFarm, EngineerMonkey, MonkeyAce	295	209	86	70.85%	1.06%	65.66%
Churchill_Sentai	BananaFarm, MonkeyAce, MonkeySub	265	188	77	70.94%	0.95%	65.48%
Benjamin	BananaFarm, DartlingGunner, NinjaMonkey	69	52	17	75.36%	0.25%	65.19%
Jericho	BananaFarm, BoomerangMonkey, MonkeySub	59	44	15	74.58%	0.21%	63.47%
Benjamin_DJ	DartlingGunner, MonkeyVillage, SuperMonkey	52	38	14	73.08%	0.19%	61.02%
Ezili	BananaFarm, BombShooter, WizardMonkey	135	92	43	68.15%	0.48%	60.29%
Adora	Alchemist, MonkeyBuccaneer, SpikeFactory	124	81	43	65.32%	0.44%	56.95%
Churchill	BananaFarm, DartMonkey, SpikeFactory	355	219	136	61.69%	1.27%	56.63%
Adora	BananaFarm, DartMonkey, MortarMonkey	62	42	20	67.74%	0.22%	56.11%
Churchill_Sentai	BananaFarm, MonkeySub, SuperMonkey	43	30	13	69.77%	0.15%	56.04%
Bonnie	MonkeyBuccaneer, SpikeFactory, SuperMonkey	59	40	19	67.80%	0.21%	55.87%
Bonnie	Alchemist, MonkeyBuccaneer, SpikeFactory	3670	2104	1566	57.33%	13.14%	55.73%
Obyn	DartlingGunner, Druid, SpikeFactory	115	74	41	64.35%	0.41%	55.59%
Adora	BananaFarm, DartMonkey, SpikeFactory	107	69	38	64.49%	0.38%	55.42%
Churchill_Sentai	BananaFarm, IceMonkey, MonkeySub	900	526	374	58.44%	3.22%	55.22%
Churchill_Sentai	BananaFarm, BombShooter, MonkeySub	1350	776	574	57.48%	4.84%	54.84%
Churchill_Sentai	BananaFarm, DartMonkey, SpikeFactory	120	76	44	63.33%	0.43%	54.71%
Etienne	BananaFarm, DartMonkey, SpikeFactory	166	103	63	62.05%	0.59%	54.67%
Quincy_Cyber	BananaFarm, TackShooter, WizardMonkey	99	63	36	63.64%	0.35%	54.16%
Jericho	DartMonkey, GlueGunner, MonkeySub	120	74	46	61.67%	0.43%	52.97%
Adora	BananaFarm, DartlingGunner, SuperMonkey	42	28	14	66.67%	0.15%	52.41%
Quincy_Cyber	BananaFarm, DartMonkey, WizardMonkey	68	43	25	63.24%	0.24%	51.77%
StrikerJones	DartlingGunner, HeliPilot, MortarMonkey	33	22	11	66.67%	0.12%	50.58%
Benjamin	Alchemist, MonkeyBuccaneer, SpikeFactory	236	134	102	56.78%	0.85%	50.46%
Etienne	EngineerMonkey, TackShooter, WizardMonkey	145	84	61	57.93%	0.52%	49.90%
Obyn	BananaFarm, Druid, MonkeySub	524	281	243	53.63%	1.88%	49.36%
Quincy	Alchemist, MonkeyBuccaneer, SpikeFactory	241	134	107	55.60%	0.86%	49.33%
Quincy_Cyber	Alchemist, MonkeyBuccaneer, SpikeFactory	226	124	102	54.87%	0.81%	48.38%
Quincy	BananaFarm, DartMonkey, SpikeFactory	29	19	10	65.52%	0.10%	48.22%
Etienne	BananaFarm, BoomerangMonkey, SniperMonkey	36	23	13	63.89%	0.13%	48.20%
Churchill	BananaFarm, BombShooter, MonkeySub	460	237	223	51.52%	1.65%	46.95%
Churchill_Sentai	Alchemist, MonkeyBuccaneer, SpikeFactory	94	53	41	56.38%	0.34%	46.36%
Bonnie	Druid, SniperMonkey, SuperMonkey	52	31	21	59.62%	0.19%	46.28%
Etienne	Alchemist, MonkeyBuccaneer, SpikeFactory	259	134	125	51.74%	0.93%	45.65%
Churchill	Alchemist, MonkeyBuccaneer, SpikeFactory	189	99	90	52.38%	0.68%	45.26%
Gwendolin	Alchemist, MonkeyBuccaneer, SpikeFactory	59	34	25	57.63%	0.21%	45.02%
Bonnie	BananaFarm, TackShooter, WizardMonkey	29	18	11	62.07%	0.10%	44.41%
Etienne_Bee	BananaFarm, BoomerangMonkey, MonkeyBuccaneer	29	18	11	62.07%	0.10%	44.41%
Bonnie	DartlingGunner, SniperMonkey, SpikeFactory	55	31	24	56.36%	0.20%	43.26%
Bonnie	MonkeyBuccaneer, SpikeFactory, WizardMonkey	50	28	22	56.00%	0.18%	42.24%
Churchill	BananaFarm, MonkeyAce, MonkeySub	45	25	20	55.56%	0.16%	41.04%
Etienne	GlueGunner, MonkeyBuccaneer, SniperMonkey	27	16	11	59.26%	0.10%	40.73%
Churchill_Sentai	BananaFarm, MonkeySub, SpikeFactory	170	82	88	48.24%	0.61%	40.72%
Adora_Fateweaver	Alchemist, MonkeyBuccaneer, SpikeFactory	29	17	12	58.62%	0.10%	40.70%
Etienne	BananaFarm, SniperMonkey, TackShooter	82	42	40	51.22%	0.29%	40.40%

Advanced export

JSON shape: default, array, newline-delimited

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

salmon_pool_hero_loadouts (view)

120 rows

Advanced export