inflection_heroes (view)

18 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Adora 681 440 241 64.61% 24.06% 61.02%
PatFusty_Snowman 73 42 31 57.53% 2.58% 46.20%
Benjamin 98 53 45 54.08% 3.46% 44.22%
Quincy_Cyber 169 87 82 51.48% 5.97% 43.94%
Etienne_Bee 260 124 136 47.69% 9.19% 41.62%
Quincy 332 154 178 46.39% 11.73% 41.02%
Churchill 129 64 65 49.61% 4.56% 40.98%
Churchill_Sentai 112 56 56 50.00% 3.96% 40.74%
Adora_Fateweaver 53 28 25 52.83% 1.87% 39.39%
Etienne 316 133 183 42.09% 11.17% 36.65%
Bonnie 216 88 128 40.74% 7.63% 34.19%
Jericho_StarCaptain 23 12 11 52.17% 0.81% 31.76%
Jericho 69 29 40 42.03% 2.44% 30.38%
Gwendolin 71 29 42 40.85% 2.51% 29.41%
Obyn 55 21 34 38.18% 1.94% 25.34%
Jericho_Highwayman 29 12 17 41.38% 1.02% 23.45%
Gwendolin_Science 54 16 38 29.63% 1.91% 17.45%
Ezili 40 10 30 25.00% 1.41% 11.58%

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;