season_31_matches: sands_of_time_hero

36 rows

descending

Hero	Loadout	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Jericho	BananaFarm, TackShooter, WizardMonkey	54	43	11	79.63%	0.88%	68.89%
PatFusty_Snowman	BananaFarm, DartlingGunner, IceMonkey	152	106	46	69.74%	2.48%	62.43%
Jericho	BananaFarm, EngineerMonkey, MonkeyAce	84	60	24	71.43%	1.37%	61.77%
Obyn	BananaFarm, Druid, MonkeySub	394	239	155	60.66%	6.44%	55.84%
Obyn	DartlingGunner, Druid, SpikeFactory	42	29	13	69.05%	0.69%	55.07%
Benjamin	BananaFarm, DartlingGunner, NinjaMonkey	81	51	30	62.96%	1.32%	52.45%
Quincy_Cyber	BananaFarm, EngineerMonkey, WizardMonkey	44	29	15	65.91%	0.72%	51.90%
Quincy_Cyber	BananaFarm, TackShooter, WizardMonkey	150	89	61	59.33%	2.45%	51.47%
PatFusty_Snowman	DartlingGunner, IceMonkey, MonkeyVillage	32	21	11	65.63%	0.52%	49.17%
StrikerJones_Biker	BananaFarm, HeliPilot, IceMonkey	33	20	13	60.61%	0.54%	43.93%
Benjamin	DartlingGunner, MonkeyVillage, SuperMonkey	207	103	104	49.76%	3.38%	42.95%
Etienne	BananaFarm, BoomerangMonkey, SniperMonkey	26	16	10	61.54%	0.42%	42.84%
Jericho_Highwayman	BananaFarm, TackShooter, WizardMonkey	30	18	12	60.00%	0.49%	42.47%
Quincy_Cyber	BananaFarm, NinjaMonkey, WizardMonkey	34	20	14	58.82%	0.56%	42.28%
Etienne_Bee	BananaFarm, IceMonkey, MonkeySub	44	25	19	56.82%	0.72%	42.18%
Etienne_Bee	BananaFarm, BoomerangMonkey, NinjaMonkey	71	37	34	52.11%	1.16%	40.49%
Ezili	BananaFarm, NinjaMonkey, WizardMonkey	50	26	24	52.00%	0.82%	38.15%
Etienne_Bee	BananaFarm, BoomerangMonkey, SpikeFactory	33	18	15	54.55%	0.54%	37.56%
StrikerJones_Biker	HeliPilot, IceMonkey, MonkeyVillage	101	47	54	46.53%	1.65%	36.81%
Quincy	BananaFarm, TackShooter, WizardMonkey	73	35	38	47.95%	1.19%	36.48%
Churchill_Sentai	BananaFarm, EngineerMonkey, SuperMonkey	24	13	11	54.17%	0.39%	34.23%
Bonnie	BananaFarm, SniperMonkey, WizardMonkey	32	16	16	50.00%	0.52%	32.68%
Ezili	BananaFarm, BombShooter, WizardMonkey	25	13	12	52.00%	0.41%	32.42%
Quincy_Cyber	BananaFarm, BoomerangMonkey, NinjaMonkey	23	12	11	52.17%	0.38%	31.76%
Quincy_Cyber	BananaFarm, IceMonkey, MonkeySub	23	12	11	52.17%	0.38%	31.76%
Gwendolin_Science	GlueGunner, MonkeyVillage, TackShooter	69	29	40	42.03%	1.13%	30.38%
Jericho	BananaFarm, IceMonkey, MonkeySub	35	16	19	45.71%	0.57%	29.21%
StrikerJones_Biker	GlueGunner, HeliPilot, MonkeyVillage	22	11	11	50.00%	0.36%	29.11%
Etienne	EngineerMonkey, TackShooter, WizardMonkey	33	15	18	45.45%	0.54%	28.47%
Quincy	BananaFarm, IceMonkey, MonkeySub	25	12	13	48.00%	0.41%	28.42%
Bonnie	DartMonkey, MonkeyVillage, SuperMonkey	20	10	10	50.00%	0.33%	28.09%
Bonnie	Alchemist, MonkeyBuccaneer, SpikeFactory	29	13	16	44.83%	0.47%	26.73%
Benjamin	BananaFarm, DartlingGunner, SuperMonkey	48	19	29	39.58%	0.78%	25.75%
PatFusty	MonkeySub, MonkeyVillage, SuperMonkey	42	17	25	40.48%	0.69%	25.63%
Churchill_Sentai	BananaFarm, IceMonkey, MonkeySub	43	16	27	37.21%	0.70%	22.76%
Bonnie	DartMonkey, SniperMonkey, SpikeFactory	27	11	16	40.74%	0.44%	22.21%

Advanced export

JSON shape: default, array, newline-delimited

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

sands_of_time_hero_loadouts (view)

36 rows

Advanced export