glade_heroes (view)

18 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Adora 472 298 174 63.14% 13.87% 58.78%
Quincy_Cyber 226 131 95 57.96% 6.64% 51.53%
Churchill_Sentai 306 169 137 55.23% 8.99% 49.66%
Churchill 233 125 108 53.65% 6.85% 47.24%
Quincy 381 198 183 51.97% 11.20% 46.95%
Adora_Fateweaver 54 31 23 57.41% 1.59% 44.22%
Etienne_Bee 451 220 231 48.78% 13.26% 44.17%
Benjamin 97 49 48 50.52% 2.85% 40.57%
Bonnie 225 105 120 46.67% 6.61% 40.15%
Etienne 482 195 287 40.46% 14.17% 36.07%
Jericho 85 38 47 44.71% 2.50% 34.14%
PatFusty_Snowman 43 21 22 48.84% 1.26% 33.90%
Jericho_StarCaptain 33 16 17 48.48% 0.97% 31.43%
Obyn 45 20 25 44.44% 1.32% 29.93%
Jericho_Highwayman 37 14 23 37.84% 1.09% 22.21%
Gwendolin_Science 69 21 48 30.43% 2.03% 19.58%
Ezili 38 13 25 34.21% 1.12% 19.13%
Gwendolin 47 13 34 27.66% 1.38% 14.87%

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;