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 384 261 123 67.97% 12.77% 63.30%
Adora_Fateweaver 59 40 19 67.80% 1.96% 55.87%
Benjamin 103 66 37 64.08% 3.43% 54.81%
Churchill_Sentai 194 107 87 55.15% 6.45% 48.16%
Jericho_StarCaptain 36 22 14 61.11% 1.20% 45.19%
Bonnie 309 156 153 50.49% 10.28% 44.91%
PatFusty_Snowman 87 48 39 55.17% 2.89% 44.72%
Quincy 283 142 141 50.18% 9.41% 44.35%
Etienne_Bee 214 107 107 50.00% 7.12% 43.30%
Churchill 251 119 132 47.41% 8.35% 41.23%
Etienne 560 247 313 44.11% 18.63% 39.99%
PatFusty 25 14 11 56.00% 0.83% 36.54%
Quincy_Cyber 55 23 32 41.82% 1.83% 28.78%
Gwendolin_Science 94 33 61 35.11% 3.13% 25.46%
Jericho 122 41 81 33.61% 4.06% 25.22%
Gwendolin 58 21 37 36.21% 1.93% 23.84%
Obyn_Ocean 25 10 15 40.00% 0.83% 20.80%
Jericho_Highwayman 31 10 21 32.26% 1.03% 15.80%
Obyn 47 11 36 23.40% 1.56% 11.30%

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;