koru_heroes (view)

23 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 199 143 56 71.86% 5.25% 65.61%
Adora_Fateweaver 102 64 38 62.75% 2.69% 53.36%
Adora 136 83 53 61.03% 3.59% 52.83%
Quincy 323 187 136 57.89% 8.52% 52.51%
Benjamin_DJ 54 33 21 61.11% 1.42% 48.11%
Jericho 307 158 149 51.47% 8.10% 45.88%
Etienne_Bee 303 156 147 51.49% 7.99% 45.86%
Benjamin 93 51 42 54.84% 2.45% 44.72%
Ezili 214 108 106 50.47% 5.65% 43.77%
Quincy_Cyber 145 73 72 50.34% 3.83% 42.21%
Jericho_Highwayman 72 38 34 52.78% 1.90% 41.25%
Etienne 746 330 416 44.24% 19.68% 40.67%
Jericho_StarCaptain 144 66 78 45.83% 3.80% 37.70%
Obyn 99 47 52 47.47% 2.61% 37.64%
Gwendolin 103 48 55 46.60% 2.72% 36.97%
StrikerJones_Biker 38 19 19 50.00% 1.00% 34.10%
Bonnie 256 102 154 39.84% 6.75% 33.85%
Gwendolin_Science 192 77 115 40.10% 5.07% 33.17%
PatFusty 50 22 28 44.00% 1.32% 30.24%
Obyn_Ocean 53 21 32 39.62% 1.40% 26.45%
Churchill 46 17 29 36.96% 1.21% 23.01%
StrikerJones 45 15 30 33.33% 1.19% 19.56%
Churchill_Sentai 42 13 29 30.95% 1.11% 16.97%

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;