season_26_matches: dino_graveyard_hero

39 rows

descending

Hero	Loadout	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Jericho	BananaFarm, EngineerMonkey, MonkeyAce	431	303	128	70.30%	6.19%	65.99%
Bonnie	MonkeyAce, MonkeyVillage, SpikeFactory	54	41	13	75.93%	0.78%	64.52%
Obyn	BananaFarm, Druid, MonkeySub	275	186	89	67.64%	3.95%	62.11%
Bonnie	Alchemist, MonkeyAce, SpikeFactory	36	26	10	72.22%	0.52%	57.59%
Jericho_Highwayman	BananaFarm, EngineerMonkey, MonkeyAce	73	48	25	65.75%	1.05%	54.87%
PatFusty_Snowman	BananaFarm, DartlingGunner, IceMonkey	90	58	32	64.44%	1.29%	54.55%
Gwendolin	DartlingGunner, Druid, MonkeyVillage	32	22	10	68.75%	0.46%	52.69%
Bonnie	Alchemist, MonkeyBuccaneer, SpikeFactory	112	69	43	61.61%	1.61%	52.60%
Adora	BananaFarm, DartMonkey, MortarMonkey	31	21	10	67.74%	0.45%	51.29%
Benjamin_DJ	DartlingGunner, MonkeyVillage, SuperMonkey	59	37	22	62.71%	0.85%	50.37%
Etienne	BananaFarm, EngineerMonkey, MonkeyAce	47	30	17	63.83%	0.68%	50.09%
Benjamin	DartlingGunner, MonkeyVillage, SuperMonkey	84	50	34	59.52%	1.21%	49.03%
Etienne_Bee	BananaFarm, BoomerangMonkey, NinjaMonkey	33	21	12	63.64%	0.47%	47.22%
Ezili	BananaFarm, BombShooter, WizardMonkey	42	25	17	59.52%	0.60%	44.68%
Bonnie	MonkeyAce, SniperMonkey, WizardMonkey	29	18	11	62.07%	0.42%	44.41%
Gwendolin_Science	GlueGunner, HeliPilot, MonkeyVillage	181	91	90	50.28%	2.60%	42.99%
Etienne_Bee	BananaFarm, BoomerangMonkey, SuperMonkey	35	20	15	57.14%	0.50%	40.75%
Jericho_StarCaptain	BananaFarm, EngineerMonkey, MonkeyAce	54	29	25	53.70%	0.78%	40.40%
Etienne	MonkeyVillage, SniperMonkey, TackShooter	43	23	20	53.49%	0.62%	38.58%
Etienne	BananaFarm, BoomerangMonkey, SpikeFactory	35	19	16	54.29%	0.50%	37.78%
Etienne	BananaFarm, DartMonkey, GlueGunner	51	26	25	50.98%	0.73%	37.26%
PatFusty_Snowman	DartlingGunner, IceMonkey, MonkeyVillage	34	18	16	52.94%	0.49%	36.16%
Bonnie	Alchemist, DartlingGunner, SpikeFactory	37	19	18	51.35%	0.53%	35.25%
Obyn	Alchemist, Druid, MonkeyVillage	33	17	16	51.52%	0.47%	34.46%
Bonnie	DartlingGunner, SpikeFactory, SuperMonkey	43	21	22	48.84%	0.62%	33.90%
PatFusty_Snowman	HeliPilot, IceMonkey, SuperMonkey	22	12	10	54.55%	0.32%	33.74%
Etienne_Bee	DartlingGunner, Druid, MonkeyVillage	47	22	25	46.81%	0.68%	32.54%
Etienne	BombShooter, DartlingGunner, MonkeyBuccaneer	25	13	12	52.00%	0.36%	32.42%
Bonnie	DartlingGunner, MonkeyVillage, SpikeFactory	30	15	15	50.00%	0.43%	32.11%
Jericho	BananaFarm, DartMonkey, MortarMonkey	21	11	10	52.38%	0.30%	31.02%
Jericho	BananaFarm, TackShooter, WizardMonkey	22	11	11	50.00%	0.32%	29.11%
Gwendolin_Science	GlueGunner, MonkeyVillage, NinjaMonkey	54	22	32	40.74%	0.78%	27.64%
Obyn_Ocean	Alchemist, HeliPilot, NinjaMonkey	37	16	21	43.24%	0.53%	27.28%
Benjamin_DJ	BananaFarm, DartlingGunner, SuperMonkey	24	11	13	45.83%	0.34%	25.90%
Benjamin	Alchemist, MonkeyBuccaneer, SpikeFactory	27	12	15	44.44%	0.39%	25.70%
Etienne	EngineerMonkey, TackShooter, WizardMonkey	33	14	19	42.42%	0.47%	25.56%
Quincy	Alchemist, MonkeyBuccaneer, SpikeFactory	23	10	13	43.48%	0.33%	23.22%
Benjamin	BananaFarm, DartlingGunner, SuperMonkey	59	20	39	33.90%	0.85%	21.82%
Obyn_Ocean	Alchemist, BananaFarm, NinjaMonkey	37	12	25	32.43%	0.53%	17.35%

Advanced export

JSON shape: default, array, newline-delimited

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

dino_graveyard_hero_loadouts (view)

39 rows

Advanced export