inflection_heroes (view)

17 rows

✎ View and edit SQL

This data as json, CSV (advanced)

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

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Benjamin 100 75 25 75.00% 3.97% 66.51%
Quincy_Cyber 585 333 252 56.92% 23.25% 52.91%
Adora 373 206 167 55.23% 14.83% 50.18%
Churchill_Sentai 112 66 46 58.93% 4.45% 49.82%
PatFusty_Snowman 54 32 22 59.26% 2.15% 46.15%
Quincy 313 153 160 48.88% 12.44% 43.34%
Adora_Fateweaver 30 17 13 56.67% 1.19% 38.93%
Obyn 54 27 27 50.00% 2.15% 36.66%
Bonnie 100 42 58 42.00% 3.97% 32.33%
Etienne_Bee 168 66 102 39.29% 6.68% 31.90%
Jericho 96 40 56 41.67% 3.82% 31.80%
Etienne 244 91 153 37.30% 9.70% 31.23%
Jericho_Highwayman 26 13 13 50.00% 1.03% 30.78%
Churchill 55 22 33 40.00% 2.19% 27.05%
PatFusty 29 13 16 44.83% 1.15% 26.73%
Gwendolin 57 21 36 36.84% 2.27% 24.32%
StrikerJones_Biker 29 11 18 37.93% 1.15% 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;