glade_heroes (view)

19 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 58 45 13 77.59% 1.91% 66.85%
Quincy_Cyber 517 307 210 59.38% 17.02% 55.15%
Adora 326 193 133 59.20% 10.73% 53.87%
Churchill_Sentai 288 167 121 57.99% 9.48% 52.29%
Benjamin 86 49 37 56.98% 2.83% 46.51%
Churchill 138 72 66 52.17% 4.54% 43.84%
Quincy 291 144 147 49.48% 9.58% 43.74%
Obyn 62 31 31 50.00% 2.04% 37.55%
Etienne_Bee 308 132 176 42.86% 10.14% 37.33%
Bonnie 139 62 77 44.60% 4.58% 36.34%
Etienne 318 127 191 39.94% 10.47% 34.55%
Jericho 129 53 76 41.09% 4.25% 32.60%
Adora_Fateweaver 34 16 18 47.06% 1.12% 30.28%
Gwendolin_Science 67 28 39 41.79% 2.21% 29.98%
StrikerJones_Biker 46 19 27 41.30% 1.51% 27.08%
Ezili 39 16 23 41.03% 1.28% 25.59%
Jericho_Highwayman 27 10 17 37.04% 0.89% 18.82%
PatFusty 31 11 20 35.48% 1.02% 18.64%
Gwendolin 44 10 34 22.73% 1.45% 10.34%

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;