season_25_matches: sands_of_time_hero

38 rows

descending

Hero	Loadout	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Jericho	BananaFarm, EngineerMonkey, MonkeyAce	83	67	16	80.72%	1.22%	72.24%
Adora	BananaFarm, MonkeySub, SuperMonkey	51	39	12	76.47%	0.75%	64.83%
PatFusty_Snowman	BananaFarm, DartlingGunner, IceMonkey	114	79	35	69.30%	1.68%	60.83%
Adora	BananaFarm, DartMonkey, MortarMonkey	56	39	17	69.64%	0.83%	57.60%
PatFusty_Snowman	DartlingGunner, IceMonkey, MonkeyVillage	57	39	18	68.42%	0.84%	56.35%
Obyn	DartlingGunner, Druid, SpikeFactory	48	33	15	68.75%	0.71%	55.64%
Bonnie	Alchemist, MonkeyBuccaneer, SpikeFactory	76	48	28	63.16%	1.12%	52.31%
PatFusty_Snowman	DartMonkey, IceMonkey, MonkeyVillage	41	27	14	65.85%	0.60%	51.34%
Obyn	BananaFarm, Druid, MonkeySub	343	191	152	55.69%	5.06%	50.43%
Benjamin_DJ	DartlingGunner, MonkeyVillage, SuperMonkey	67	40	27	59.70%	0.99%	47.96%
Etienne	BananaFarm, DartMonkey, GlueGunner	127	71	56	55.91%	1.87%	47.27%
Jericho	BananaFarm, TackShooter, WizardMonkey	26	16	10	61.54%	0.38%	42.84%
Gwendolin	BananaFarm, IceMonkey, MonkeyBuccaneer	30	18	12	60.00%	0.44%	42.47%
Gwendolin_Science	GlueGunner, MonkeyVillage, NinjaMonkey	158	77	81	48.73%	2.33%	40.94%
Ezili	BananaFarm, BombShooter, WizardMonkey	69	36	33	52.17%	1.02%	40.39%
Etienne	BananaFarm, BoomerangMonkey, SniperMonkey	36	20	16	55.56%	0.53%	39.32%
Gwendolin_Science	GlueGunner, MonkeyVillage, TackShooter	67	33	34	49.25%	0.99%	37.28%
Obyn_Ocean	Alchemist, HeliPilot, NinjaMonkey	42	22	20	52.38%	0.62%	37.28%
Gwendolin_Science	GlueGunner, HeliPilot, MonkeyVillage	122	56	66	45.90%	1.80%	37.06%
Gwendolin_Science	Alchemist, GlueGunner, NinjaMonkey	46	23	23	50.00%	0.68%	35.55%
Etienne_Bee	BananaFarm, BoomerangMonkey, SpikeFactory	30	16	14	53.33%	0.44%	35.48%
Etienne	MonkeyVillage, SniperMonkey, TackShooter	35	18	17	51.43%	0.52%	34.87%
Gwendolin_Science	BananaFarm, GlueGunner, MonkeySub	30	15	15	50.00%	0.44%	32.11%
Etienne	DartMonkey, GlueGunner, MonkeyVillage	23	12	11	52.17%	0.34%	31.76%
Etienne	BananaFarm, BombShooter, SpikeFactory	43	20	23	46.51%	0.63%	31.60%
Etienne	EngineerMonkey, TackShooter, WizardMonkey	38	18	20	47.37%	0.56%	31.49%
Bonnie	Alchemist, DartlingGunner, SpikeFactory	28	14	14	50.00%	0.41%	31.48%
Gwendolin_Science	DartMonkey, GlueGunner, MonkeyVillage	31	15	16	48.39%	0.46%	30.79%
Bonnie	Druid, MonkeySub, SpikeFactory	37	17	20	45.95%	0.55%	29.89%
Obyn_Ocean	Alchemist, BananaFarm, NinjaMonkey	22	11	11	50.00%	0.32%	29.11%
Obyn	Alchemist, Druid, MonkeyVillage	41	18	23	43.90%	0.60%	28.71%
Etienne	BananaFarm, BombShooter, DartlingGunner	25	12	13	48.00%	0.37%	28.42%
Etienne_Bee	DartlingGunner, Druid, MonkeyVillage	68	26	42	38.24%	1.00%	26.68%
Obyn_Ocean	Alchemist, NinjaMonkey, SniperMonkey	21	10	11	47.62%	0.31%	26.26%
PatFusty	DartMonkey, IceMonkey, MonkeyVillage	24	10	14	41.67%	0.35%	21.94%
PatFusty	DartMonkey, GlueGunner, MonkeyVillage	25	10	15	40.00%	0.37%	20.80%
Benjamin	BananaFarm, DartlingGunner, SuperMonkey	40	13	27	32.50%	0.59%	17.98%
Gwendolin	IceMonkey, MonkeyVillage, TackShooter	28	10	18	35.71%	0.41%	17.97%

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)

38 rows

Advanced export