banana_depot_scene_heroes (view)

19 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
Jericho_Highwayman 79 55 24 69.62% 3.07% 59.48%
Adora_Fateweaver 71 47 24 66.20% 2.76% 55.19%
PatFusty_Snowman 51 32 19 62.75% 1.98% 49.48%
Quincy 184 104 80 56.52% 7.16% 49.36%
Etienne 780 404 376 51.79% 30.35% 48.29%
Jericho 178 96 82 53.93% 6.93% 46.61%
StrikerJones_Biker 28 18 10 64.29% 1.09% 46.54%
Bonnie 189 88 101 46.56% 7.35% 39.45%
Etienne_Bee 356 158 198 44.38% 13.85% 39.22%
Adora 55 28 27 50.91% 2.14% 37.70%
Ezili 69 33 36 47.83% 2.68% 36.04%
Jericho_StarCaptain 53 26 27 49.06% 2.06% 35.60%
Gwendolin_Science 148 58 90 39.19% 5.76% 31.32%
StrikerJones 39 18 21 46.15% 1.52% 30.51%
Obyn_Ocean 27 13 14 48.15% 1.05% 29.30%
Gwendolin 79 28 51 35.44% 3.07% 24.89%
Obyn 35 14 21 40.00% 1.36% 23.77%
Quincy_Cyber 51 18 33 35.29% 1.98% 22.18%
PatFusty 29 10 19 34.48% 1.13% 17.18%

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;