banana_depot_scene_heroes (view)

19 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Adora_Fateweaver 66 45 21 68.18% 2.19% 56.94%
PatFusty_Snowman 137 84 53 61.31% 4.54% 53.16%
StrikerJones 128 78 50 60.94% 4.24% 52.49%
Jericho_StarCaptain 123 72 51 58.54% 4.08% 49.83%
Ezili 117 67 50 57.26% 3.88% 48.30%
Jericho 273 143 130 52.38% 9.05% 46.46%
Etienne_Bee 347 179 168 51.59% 11.51% 46.33%
Adora 73 41 32 56.16% 2.42% 44.78%
Etienne 714 344 370 48.18% 23.67% 44.51%
Jericho_Highwayman 71 39 32 54.93% 2.35% 43.36%
Quincy 158 78 80 49.37% 5.24% 41.57%
Quincy_Cyber 74 38 36 51.35% 2.45% 39.96%
Benjamin 52 26 26 50.00% 1.72% 36.41%
Bonnie 235 97 138 41.28% 7.79% 34.98%
Gwendolin_Science 144 58 86 40.28% 4.77% 32.27%
PatFusty 44 19 25 43.18% 1.46% 28.55%
Churchill 31 14 17 45.16% 1.03% 27.64%
Gwendolin 90 32 58 35.56% 2.98% 25.67%
Obyn_Ocean 30 10 20 33.33% 0.99% 16.46%

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;