glade_heroes (view)

19 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Losses, Winrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Adora 314 225 89 71.66% 10.59% 66.67%
PatFusty_Snowman 48 32 16 66.67% 1.62% 53.33%
Churchill 327 188 139 57.49% 11.02% 52.13%
Quincy 216 125 91 57.87% 7.28% 51.29%
Quincy_Cyber 50 31 19 62.00% 1.69% 48.55%
Churchill_Sentai 159 85 74 53.46% 5.36% 45.71%
PatFusty 27 17 10 62.96% 0.91% 44.75%
Adora_Fateweaver 34 20 14 58.82% 1.15% 42.28%
Etienne 663 297 366 44.80% 22.35% 41.01%
Bonnie 275 123 152 44.73% 9.27% 38.85%
Jericho_StarCaptain 46 24 22 52.17% 1.55% 37.74%
Jericho 138 57 81 41.30% 4.65% 33.09%
Benjamin_DJ 23 12 11 52.17% 0.78% 31.76%
Gwendolin_Science 127 51 76 40.16% 4.28% 31.63%
Etienne_Bee 271 99 172 36.53% 9.14% 30.80%
Obyn 67 28 39 41.79% 2.26% 29.98%
Ezili 35 14 21 40.00% 1.18% 23.77%
Gwendolin 39 15 24 38.46% 1.31% 23.19%
Benjamin 33 11 22 33.33% 1.11% 17.25%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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