inflection_heroes (view)

19 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Benjamin_DJ 54 40 14 74.07% 1.70% 62.39%
Adora 575 352 223 61.22% 18.06% 57.23%
Churchill_Sentai 152 92 60 60.53% 4.77% 52.76%
PatFusty_Snowman 79 50 29 63.29% 2.48% 52.66%
Quincy 297 156 141 52.53% 9.33% 46.85%
Benjamin 88 48 40 54.55% 2.76% 44.14%
Bonnie 286 141 145 49.30% 8.98% 43.51%
Adora_Fateweaver 72 39 33 54.17% 2.26% 42.66%
Etienne 607 273 334 44.98% 19.06% 41.02%
Churchill 145 71 74 48.97% 4.55% 40.83%
Jericho 156 72 84 46.15% 4.90% 38.33%
Obyn 62 30 32 48.39% 1.95% 35.95%
Etienne_Bee 149 63 86 42.28% 4.68% 34.35%
Quincy_Cyber 113 46 67 40.71% 3.55% 31.65%
Jericho_StarCaptain 62 27 35 43.55% 1.95% 31.21%
Ezili 31 12 19 38.71% 0.97% 21.56%
Jericho_Highwayman 33 12 21 36.36% 1.04% 19.95%
Gwendolin 70 21 49 30.00% 2.20% 19.26%
Gwendolin_Science 70 17 53 24.29% 2.20% 14.24%

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;