banana_depot_scene_heroes (view)

18 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Winrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho 307 184 123 59.93% 9.68% 54.45%
Etienne_Bee 590 331 259 56.10% 18.61% 52.10%
Quincy_Cyber 156 92 64 58.97% 4.92% 51.26%
Bonnie 178 98 80 55.06% 5.62% 47.75%
Jericho_StarCaptain 112 60 52 53.57% 3.53% 44.33%
Jericho_Highwayman 72 39 33 54.17% 2.27% 42.66%
Benjamin 68 37 31 54.41% 2.15% 42.57%
Etienne 672 310 362 46.13% 21.20% 42.36%
Ezili 161 80 81 49.69% 5.08% 41.97%
PatFusty_Snowman 108 55 53 50.93% 3.41% 41.50%
Quincy 288 134 154 46.53% 9.09% 40.77%
StrikerJones 69 33 36 47.83% 2.18% 36.04%
Adora_Fateweaver 36 18 18 50.00% 1.14% 33.67%
StrikerJones_Biker 23 11 12 47.83% 0.73% 27.41%
Gwendolin 88 27 61 30.68% 2.78% 21.05%
Obyn 34 12 22 35.29% 1.07% 19.23%
Adora 38 13 25 34.21% 1.20% 19.13%
Gwendolin_Science 63 17 46 26.98% 1.99% 16.02%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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