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
Etienne_Bee 490 280 210 57.14% 17.91% 52.76%
Quincy_Cyber 432 245 187 56.71% 15.79% 52.04%
Jericho_StarCaptain 30 20 10 66.67% 1.10% 49.80%
StrikerJones 87 52 35 59.77% 3.18% 49.47%
Quincy 219 122 97 55.71% 8.00% 49.13%
Jericho_Highwayman 72 43 29 59.72% 2.63% 48.39%
Jericho 211 104 107 49.29% 7.71% 42.54%
Etienne 475 214 261 45.05% 17.36% 40.58%
Benjamin 49 25 24 51.02% 1.79% 37.02%
PatFusty 47 24 23 51.06% 1.72% 36.77%
Ezili 72 33 39 45.83% 2.63% 34.32%
PatFusty_Snowman 47 22 25 46.81% 1.72% 32.54%
StrikerJones_Biker 50 23 27 46.00% 1.83% 32.19%
Adora_Fateweaver 49 22 27 44.90% 1.79% 30.97%
Bonnie 117 46 71 39.32% 4.28% 30.47%
Gwendolin 63 22 41 34.92% 2.30% 23.15%
Gwendolin_Science 53 19 34 35.85% 1.94% 22.94%
Obyn_Ocean 33 12 21 36.36% 1.21% 19.95%
Adora 41 14 27 34.15% 1.50% 19.63%

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;