star_heroes (view)

19 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 111 72 39 64.86% 5.39% 55.98%
Quincy_Cyber 212 121 91 57.08% 10.29% 50.41%
PatFusty 65 38 27 58.46% 3.16% 46.48%
Obyn_Ocean 45 27 18 60.00% 2.18% 45.69%
Benjamin 211 108 103 51.18% 10.24% 44.44%
Jericho 180 93 87 51.67% 8.74% 44.37%
Ezili 69 36 33 52.17% 3.35% 40.39%
Etienne_Bee 135 65 70 48.15% 6.55% 39.72%
StrikerJones_Biker 55 29 26 52.73% 2.67% 39.53%
Etienne 159 75 84 47.17% 7.72% 39.41%
Bonnie 129 61 68 47.29% 6.26% 38.67%
Obyn 107 51 56 47.66% 5.19% 38.20%
Churchill_Sentai 141 63 78 44.68% 6.84% 36.47%
Churchill 62 30 32 48.39% 3.01% 35.95%
Gwendolin 50 24 26 48.00% 2.43% 34.15%
Gwendolin_Science 117 49 68 41.88% 5.68% 32.94%
Adora 42 19 23 45.24% 2.04% 30.19%
Jericho_StarCaptain 23 11 12 47.83% 1.12% 27.41%
Quincy 91 33 58 36.26% 4.42% 26.39%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW star_heroes AS 
WITH star AS
    (SELECT *
    FROM matches
    WHERE map = 'star')
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 star) * 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 star
                  UNION ALL
                  SELECT rHero             AS Hero,
                         NOT playerLeftWin AS Win
                  FROM star)
            GROUP BY Hero))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;