inflection_heroes (view)

18 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Adora 540 339 201 62.78% 21.55% 58.70%
Benjamin 88 55 33 62.50% 3.51% 52.38%
Etienne 390 199 191 51.03% 15.56% 46.06%
Quincy 233 115 118 49.36% 9.30% 42.94%
Adora_Fateweaver 52 28 24 53.85% 2.08% 40.30%
Jericho 104 50 54 48.08% 4.15% 38.47%
Bonnie 270 119 151 44.07% 10.77% 38.15%
Churchill 128 59 69 46.09% 5.11% 37.46%
Churchill_Sentai 84 38 46 45.24% 3.35% 34.59%
Quincy_Cyber 73 33 40 45.21% 2.91% 33.79%
Etienne_Bee 164 67 97 40.85% 6.54% 33.33%
PatFusty_Snowman 74 33 41 44.59% 2.95% 33.27%
Jericho_Highwayman 27 14 13 51.85% 1.08% 33.00%
Jericho_StarCaptain 22 10 12 45.45% 0.88% 24.65%
Obyn 34 14 20 41.18% 1.36% 24.63%
Gwendolin 63 21 42 33.33% 2.51% 21.69%
Gwendolin_Science 43 13 30 30.23% 1.72% 16.51%
PatFusty 35 11 24 31.43% 1.40% 16.05%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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