season_29_matches: off_tide

22 rows

descending

Hero	Games	Wins	Losses	Winrate	Pickrate	Winrate_LowerBound_95CI
Jericho_Highwayman	248	150	98	60.48%	4.02%	54.40%
PatFusty_Snowman	259	152	107	58.69%	4.20%	52.69%
Etienne_Bee	1203	666	537	55.36%	19.52%	52.55%
Quincy_Cyber	643	356	287	55.37%	10.43%	51.52%
Quincy	645	353	292	54.73%	10.47%	50.89%
Benjamin	186	104	82	55.91%	3.02%	48.78%
Jericho	469	238	231	50.75%	7.61%	46.22%
Ezili	289	145	144	50.17%	4.69%	44.41%
Gwendolin	119	59	60	49.58%	1.93%	40.60%
Etienne	593	252	341	42.50%	9.62%	38.52%
Bonnie	337	145	192	43.03%	5.47%	37.74%
Gwendolin_Science	206	88	118	42.72%	3.34%	35.96%
Jericho_StarCaptain	72	34	38	47.22%	1.17%	35.69%
Obyn	149	62	87	41.61%	2.42%	33.70%
StrikerJones	76	34	42	44.74%	1.23%	33.56%
Adora_Fateweaver	45	21	24	46.67%	0.73%	32.09%
Adora	112	46	66	41.07%	1.82%	31.96%
PatFusty	36	17	19	47.22%	0.58%	30.91%
Churchill_Sentai	183	69	114	37.70%	2.97%	30.68%
Obyn_Ocean	122	45	77	36.89%	1.98%	28.32%
Ezili_SmudgeCat	56	16	40	28.57%	0.91%	16.74%
StrikerJones_Biker	34	10	24	29.41%	0.55%	14.10%

Advanced export

JSON shape: default, array, newline-delimited

CREATE VIEW off_tide_heroes AS 
WITH off_tide AS
    (SELECT *
    FROM matches
    WHERE map = 'off_tide')
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 off_tide) * 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 off_tide
                  UNION ALL
                  SELECT rHero             AS Hero,
                         NOT playerLeftWin AS Win
                  FROM off_tide)
            GROUP BY Hero))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;

off_tide_heroes (view)

22 rows

Advanced export