glade_heroes (view)

9 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Quincy_Cyber 285 161 124 56.49% 33.06% 50.74%
Benjamin 64 40 24 62.50% 7.42% 50.64%
Churchill_Sentai 60 36 24 60.00% 6.96% 47.60%
Churchill 48 24 24 50.00% 5.57% 35.85%
Quincy 61 29 32 47.54% 7.08% 35.01%
Adora 68 31 37 45.59% 7.89% 33.75%
Etienne 92 37 55 40.22% 10.67% 30.20%
Etienne_Bee 44 17 27 38.64% 5.10% 24.25%
Bonnie 42 15 27 35.71% 4.87% 21.22%

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;