koru_heroes (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Quincy_Cyber 302 180 122 59.60% 7.26% 54.07%
Adora_Fateweaver 134 80 54 59.70% 3.22% 51.40%
Quincy 664 360 304 54.22% 15.97% 50.43%
PatFusty_Snowman 251 138 113 54.98% 6.04% 48.83%
Jericho 302 161 141 53.31% 7.26% 47.68%
Etienne_Bee 534 275 259 51.50% 12.84% 47.26%
Jericho_Highwayman 93 53 40 56.99% 2.24% 46.93%
Benjamin 186 97 89 52.15% 4.47% 44.97%
Ezili 219 110 109 50.23% 5.27% 43.61%
Jericho_StarCaptain 99 51 48 51.52% 2.38% 41.67%
Etienne 501 227 274 45.31% 12.05% 40.95%
Gwendolin 117 58 59 49.57% 2.81% 40.51%
Obyn 130 62 68 47.69% 3.13% 39.11%
Adora 81 39 42 48.15% 1.95% 37.27%
StrikerJones_Biker 27 14 13 51.85% 0.65% 33.00%
Churchill 30 15 15 50.00% 0.72% 32.11%
Bonnie 160 63 97 39.38% 3.85% 31.80%
Gwendolin_Science 121 41 80 33.88% 2.91% 25.45%
StrikerJones 43 13 30 30.23% 1.03% 16.51%
Churchill_Sentai 51 14 37 27.45% 1.23% 15.20%
Ezili_SmudgeCat 36 10 26 27.78% 0.87% 13.15%
Obyn_Ocean 39 10 29 25.64% 0.94% 11.94%

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;