s24+_matches: banana_depot_scene_hero

89 rows

descending

Hero	Loadout	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Etienne_Bee	BananaFarm, BombShooter, EngineerMonkey	64	52	12	81.25%	0.29%	71.69%
StrikerJones	MortarMonkey, SniperMonkey, TackShooter	229	171	58	74.67%	1.03%	69.04%
Etienne_Bee	BananaFarm, EngineerMonkey, MonkeyAce	52	40	12	76.92%	0.23%	65.47%
Quincy	BananaFarm, BombShooter, WizardMonkey	76	57	19	75.00%	0.34%	65.26%
Quincy	BananaFarm, MortarMonkey, TackShooter	380	265	115	69.74%	1.71%	65.12%
Jericho	BananaFarm, MortarMonkey, TackShooter	599	407	192	67.95%	2.69%	64.21%
Quincy_Cyber	BananaFarm, BombShooter, MonkeySub	92	67	25	72.83%	0.41%	63.74%
Jericho_Highwayman	BananaFarm, MortarMonkey, TackShooter	240	164	76	68.33%	1.08%	62.45%
Adora	BananaFarm, TackShooter, WizardMonkey	55	40	15	72.73%	0.25%	60.96%
Adora_Fateweaver	BananaFarm, MortarMonkey, TackShooter	183	121	62	66.12%	0.82%	59.26%
Bonnie	BananaFarm, TackShooter, WizardMonkey	37	27	10	72.97%	0.17%	58.66%
Adora	BananaFarm, MortarMonkey, TackShooter	98	66	32	67.35%	0.44%	58.06%
Quincy_Cyber	BananaFarm, TackShooter, WizardMonkey	779	475	304	60.98%	3.50%	57.55%
Quincy_Cyber	BananaFarm, BombShooter, WizardMonkey	133	87	46	65.41%	0.60%	57.33%
Ezili	BananaFarm, BombShooter, WizardMonkey	445	275	170	61.80%	2.00%	57.28%
Bonnie	MortarMonkey, SpikeFactory, TackShooter	80	54	26	67.50%	0.36%	57.24%
StrikerJones	BananaFarm, BombShooter, MortarMonkey	118	77	41	65.25%	0.53%	56.66%
Quincy_Cyber	BananaFarm, MortarMonkey, TackShooter	199	126	73	63.32%	0.89%	56.62%
StrikerJones_Biker	BananaFarm, MonkeyAce, SpikeFactory	40	28	12	70.00%	0.18%	55.80%
Jericho_Highwayman	BananaFarm, TackShooter, WizardMonkey	228	141	87	61.84%	1.02%	55.54%
Jericho_StarCaptain	BananaFarm, BombShooter, MonkeySub	42	29	13	69.05%	0.19%	55.07%
Etienne_Bee	BananaFarm, BombShooter, SpikeFactory	1589	904	685	56.89%	7.14%	54.46%
Bonnie	BombShooter, SpikeFactory, WizardMonkey	152	94	58	61.84%	0.68%	54.12%
Benjamin	BananaFarm, TackShooter, WizardMonkey	199	121	78	60.80%	0.89%	54.02%
Jericho_StarCaptain	BananaFarm, MortarMonkey, TackShooter	180	108	72	60.00%	0.81%	52.84%
Etienne	BananaFarm, BombShooter, SpikeFactory	2013	1106	907	54.94%	9.05%	52.77%
Jericho_StarCaptain	BananaFarm, TackShooter, WizardMonkey	210	122	88	58.10%	0.94%	51.42%
Etienne_Bee	BananaFarm, MortarMonkey, TackShooter	79	49	30	62.03%	0.36%	51.32%
PatFusty_Snowman	BananaFarm, IceMonkey, TackShooter	142	82	60	57.75%	0.64%	49.62%
Etienne_Bee	BananaFarm, BombShooter, WizardMonkey	32	21	11	65.63%	0.14%	49.17%
Jericho	BananaFarm, TackShooter, WizardMonkey	404	217	187	53.71%	1.82%	48.85%
PatFusty_Snowman	HeliPilot, IceMonkey, SuperMonkey	54	33	21	61.11%	0.24%	48.11%
Bonnie	SpikeFactory, TackShooter, WizardMonkey	191	105	86	54.97%	0.86%	47.92%
StrikerJones	BananaFarm, BombShooter, WizardMonkey	38	24	14	63.16%	0.17%	47.82%
Etienne	BananaFarm, BombShooter, TackShooter	40	25	15	62.50%	0.18%	47.50%
Etienne_Bee	BananaFarm, BombShooter, MonkeySub	39	24	15	61.54%	0.18%	46.27%
Etienne_Bee	BananaFarm, BombShooter, TackShooter	87	49	38	56.32%	0.39%	45.90%
Jericho_Highwayman	BananaFarm, BombShooter, MonkeySub	47	28	19	59.57%	0.21%	45.54%
Adora_Fateweaver	BananaFarm, TackShooter, WizardMonkey	78	44	34	56.41%	0.35%	45.41%
Jericho	BananaFarm, BombShooter, MonkeySub	217	112	105	51.61%	0.98%	44.96%
Quincy	BananaFarm, TackShooter, WizardMonkey	399	197	202	49.37%	1.79%	44.47%
Etienne	SpikeFactory, TackShooter, WizardMonkey	158	82	76	51.90%	0.71%	44.11%
Etienne_Bee	BananaFarm, TackShooter, WizardMonkey	79	43	36	54.43%	0.36%	43.45%
PatFusty	BananaFarm, TackShooter, WizardMonkey	43	25	18	58.14%	0.19%	43.39%
PatFusty_Snowman	IceMonkey, MonkeyVillage, TackShooter	28	17	11	60.71%	0.13%	42.62%
Etienne	BananaFarm, BombShooter, MonkeySub	37	21	16	56.76%	0.17%	40.79%
Etienne	GlueGunner, SniperMonkey, TackShooter	29	17	12	58.62%	0.13%	40.70%
Etienne	BananaFarm, MortarMonkey, TackShooter	87	44	43	50.57%	0.39%	40.07%
Etienne	BananaFarm, BombShooter, GlueGunner	32	18	14	56.25%	0.14%	39.06%
Etienne	BananaFarm, SpikeFactory, TackShooter	103	50	53	48.54%	0.46%	38.89%

Advanced export

JSON shape: default, array, newline-delimited

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

banana_depot_scene_hero_loadouts (view)

89 rows

Advanced export