inflection_heroes (view)

15 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Benjamin 154 105 49 68.18% 6.29% 60.83%
Adora 255 159 96 62.35% 10.41% 56.41%
Quincy_Cyber 702 363 339 51.71% 28.65% 48.01%
Quincy 319 157 162 49.22% 13.02% 43.73%
PatFusty_Snowman 49 27 22 55.10% 2.00% 41.18%
Churchill_Sentai 118 57 61 48.31% 4.82% 39.29%
Obyn 47 25 22 53.19% 1.92% 38.93%
Etienne 234 106 128 45.30% 9.55% 38.92%
Etienne_Bee 100 44 56 44.00% 4.08% 34.27%
Bonnie 119 51 68 42.86% 4.86% 33.97%
Jericho_StarCaptain 21 11 10 52.38% 0.86% 31.02%
Churchill 57 25 32 43.86% 2.33% 30.98%
Jericho 74 30 44 40.54% 3.02% 29.35%
PatFusty 27 11 16 40.74% 1.10% 22.21%
StrikerJones_Biker 29 11 18 37.93% 1.18% 20.27%

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;