season_27_matches: cobra_command

23 rows

descending

Hero	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Adora_Fateweaver	44	32	12	72.73%	0.90%	59.57%
Etienne	1333	722	611	54.16%	27.16%	51.49%
Jericho	252	141	111	55.95%	5.13%	49.82%
Etienne_Bee	629	330	299	52.46%	12.82%	48.56%
Ezili	132	75	57	56.82%	2.69%	48.37%
StrikerJones	158	86	72	54.43%	3.22%	46.66%
Bonnie	527	259	268	49.15%	10.74%	44.88%
Gwendolin_Science	284	139	145	48.94%	5.79%	43.13%
Quincy	287	133	154	46.34%	5.85%	40.57%
Benjamin	201	89	112	44.28%	4.10%	37.41%
PatFusty_Snowman	136	61	75	44.85%	2.77%	36.49%
Jericho_StarCaptain	56	27	29	48.21%	1.14%	35.13%
Obyn	83	38	45	45.78%	1.69%	35.06%
Ezili_SmudgeCat	29	15	14	51.72%	0.59%	33.54%
Gwendolin	126	53	73	42.06%	2.57%	33.44%
PatFusty	46	22	24	47.83%	0.94%	33.39%
Quincy_Cyber	72	32	40	44.44%	1.47%	32.97%
Adora	132	54	78	40.91%	2.69%	32.52%
Obyn_Ocean	93	39	54	41.94%	1.89%	31.91%
Churchill_Sentai	82	32	50	39.02%	1.67%	28.47%
Jericho_Highwayman	57	23	34	40.35%	1.16%	27.61%
StrikerJones_Biker	42	17	25	40.48%	0.86%	25.63%
Churchill	75	26	49	34.67%	1.53%	23.90%

Advanced export

JSON shape: default, array, newline-delimited

CREATE VIEW cobra_command_heroes AS 
WITH cobra_command AS
    (SELECT *
    FROM matches
    WHERE map = 'cobra_command')
SELECT Hero,
       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,
             Games,
             Wins,
             Losses,
             CAST(Wins AS REAL) / Games AS WR,
             CAST(Games AS REAL) / (
                 (SELECT COUNT(*)
                  FROM cobra_command) * 2)    AS PR
      FROM (SELECT Hero,
                   SUM(Win) + SUM(NOT Win) AS Games,
                   SUM(Win)                AS Wins,
                   SUM(NOT Win)            AS Losses
            FROM (SELECT lHero             AS Hero,
                         playerLeftWin     AS Win
                  FROM cobra_command
                  UNION ALL
                  SELECT rHero             AS Hero,
                         NOT playerLeftWin AS Win
                  FROM cobra_command)
            GROUP BY Hero))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;

cobra_command_heroes (view)

23 rows

Advanced export