glade_heroes (view)

19 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
Adora 410 248 162 60.49% 12.06% 55.76%
Churchill_Sentai 398 221 177 55.53% 11.71% 50.65%
Quincy 392 210 182 53.57% 11.53% 48.63%
Quincy_Cyber 458 242 216 52.84% 13.47% 48.27%
Benjamin 80 47 33 58.75% 2.35% 47.96%
Churchill 208 107 101 51.44% 6.12% 44.65%
Jericho_Highwayman 62 35 27 56.45% 1.82% 44.11%
PatFusty_Snowman 39 22 17 56.41% 1.15% 40.85%
Adora_Fateweaver 29 17 12 58.62% 0.85% 40.70%
Etienne_Bee 403 181 222 44.91% 11.85% 40.06%
Ezili 72 35 37 48.61% 2.12% 37.07%
Bonnie 133 60 73 45.11% 3.91% 36.66%
Etienne 271 102 169 37.64% 7.97% 31.87%
Obyn 89 35 54 39.33% 2.62% 29.18%
Gwendolin_Science 45 18 27 40.00% 1.32% 25.69%
Jericho 134 45 89 33.58% 3.94% 25.59%
Obyn_Ocean 41 16 25 39.02% 1.21% 24.09%
Gwendolin 37 14 23 37.84% 1.09% 22.21%
Ezili_SmudgeCat 37 13 24 35.14% 1.09% 19.75%

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;