inflection_heroes (view)

17 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Winrate, Pickrate, Winrate_LowerBound_95CI

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Adora 582 365 217 62.71% 19.49% 58.79%
Quincy_Cyber 552 325 227 58.88% 18.49% 54.77%
Quincy 476 238 238 50.00% 15.94% 45.51%
Churchill_Sentai 131 68 63 51.91% 4.39% 43.35%
Benjamin 78 40 38 51.28% 2.61% 40.19%
Etienne_Bee 234 105 129 44.87% 7.84% 38.50%
Adora_Fateweaver 38 19 19 50.00% 1.27% 34.10%
Etienne 238 96 142 40.34% 7.97% 34.10%
Jericho 81 36 45 44.44% 2.71% 33.62%
Jericho_Highwayman 35 17 18 48.57% 1.17% 32.01%
PatFusty_Snowman 41 17 24 41.46% 1.37% 26.38%
Bonnie 159 52 107 32.70% 5.32% 25.41%
Churchill 90 30 60 33.33% 3.01% 23.59%
Obyn 60 20 40 33.33% 2.01% 21.41%
Gwendolin_Science 38 13 25 34.21% 1.27% 19.13%
Gwendolin 34 10 24 29.41% 1.14% 14.10%
Ezili 36 10 26 27.78% 1.21% 13.15%

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;