koru_heroes (view)

20 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_Fateweaver 135 100 35 74.07% 3.80% 66.68%
PatFusty_Snowman 177 117 60 66.10% 4.99% 59.13%
Ezili_SmudgeCat 42 29 13 69.05% 1.18% 55.07%
Quincy 324 180 144 55.56% 9.13% 50.14%
Jericho_StarCaptain 69 41 28 59.42% 1.94% 47.83%
Adora 163 89 74 54.60% 4.59% 46.96%
Etienne_Bee 442 223 219 50.45% 12.46% 45.79%
Etienne 763 348 415 45.61% 21.51% 42.08%
Quincy_Cyber 106 54 52 50.94% 2.99% 41.43%
Jericho 180 86 94 47.78% 5.07% 40.48%
Benjamin 55 29 26 52.73% 1.55% 39.53%
Obyn 100 49 51 49.00% 2.82% 39.20%
Ezili 192 88 104 45.83% 5.41% 38.79%
Bonnie 241 106 135 43.98% 6.79% 37.72%
Gwendolin 125 53 72 42.40% 3.52% 33.74%
PatFusty 55 24 31 43.64% 1.55% 30.53%
Gwendolin_Science 187 68 119 36.36% 5.27% 29.47%
Churchill 46 18 28 39.13% 1.30% 25.03%
Jericho_Highwayman 41 16 25 39.02% 1.16% 24.09%
Obyn_Ocean 26 10 16 38.46% 0.73% 19.76%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW koru_heroes AS 
WITH koru AS
    (SELECT *
    FROM matches
    WHERE map = 'koru')
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 koru) * 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 koru
                  UNION ALL
                  SELECT rHero             AS Hero,
                         NOT playerLeftWin AS Win
                  FROM koru)
            GROUP BY Hero))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;