glade_heroes (view)

17 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 54 37 17 68.52% 1.77% 56.13%
Quincy_Cyber 790 451 339 57.09% 25.94% 53.64%
Adora 206 123 83 59.71% 6.76% 53.01%
Benjamin 146 87 59 59.59% 4.79% 51.63%
Churchill_Sentai 286 156 130 54.55% 9.39% 48.77%
Quincy 296 140 156 47.30% 9.72% 41.61%
Etienne 354 163 191 46.05% 11.62% 40.85%
Etienne_Bee 177 83 94 46.89% 5.81% 39.54%
StrikerJones_Biker 60 31 29 51.67% 1.97% 39.02%
Churchill 191 84 107 43.98% 6.27% 36.94%
Jericho 75 30 45 40.00% 2.46% 28.91%
Obyn 30 14 16 46.67% 0.98% 28.81%
Bonnie 134 48 86 35.82% 4.40% 27.70%
StrikerJones 22 10 12 45.45% 0.72% 24.65%
Jericho_StarCaptain 27 10 17 37.04% 0.89% 18.82%
Gwendolin 39 12 27 30.77% 1.28% 16.28%
Jericho_Highwayman 39 10 29 25.64% 1.28% 11.94%

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;