inflection_heroes (view)

19 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 59 43 16 72.88% 2.11% 61.54%
Adora 516 313 203 60.66% 18.48% 56.44%
Churchill_Sentai 97 62 35 63.92% 3.47% 54.36%
Adora_Fateweaver 70 42 28 60.00% 2.51% 48.52%
Etienne 579 280 299 48.36% 20.74% 44.29%
Etienne_Bee 210 102 108 48.57% 7.52% 41.81%
Churchill 112 57 55 50.89% 4.01% 41.63%
Quincy 237 111 126 46.84% 8.49% 40.48%
Jericho 149 65 84 43.62% 5.34% 35.66%
Gwendolin 59 28 31 47.46% 2.11% 34.72%
Bonnie 275 111 164 40.36% 9.85% 34.56%
Jericho_StarCaptain 33 16 17 48.48% 1.18% 31.43%
PatFusty 34 16 18 47.06% 1.22% 30.28%
Obyn 56 24 32 42.86% 2.01% 29.90%
Gwendolin_Science 98 37 61 37.76% 3.51% 28.16%
Benjamin 38 16 22 42.11% 1.36% 26.41%
Ezili 25 11 14 44.00% 0.90% 24.54%
Quincy_Cyber 43 15 28 34.88% 1.54% 20.64%
Jericho_Highwayman 33 11 22 33.33% 1.18% 17.25%

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;