banana_depot_scene_heroes (view)

17 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Losses, Winrate, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Quincy_Cyber 399 250 149 62.66% 13.55% 57.91%
Jericho_Highwayman 158 100 58 63.29% 5.37% 55.78%
StrikerJones 80 49 31 61.25% 2.72% 50.57%
Etienne_Bee 654 340 314 51.99% 22.21% 48.16%
Jericho_StarCaptain 55 33 22 60.00% 1.87% 47.05%
Jericho 240 122 118 50.83% 8.15% 44.51%
Quincy 309 150 159 48.54% 10.50% 42.97%
Benjamin 44 24 20 54.55% 1.49% 39.83%
Bonnie 153 72 81 47.06% 5.20% 39.15%
Ezili 74 36 38 48.65% 2.51% 37.26%
Adora_Fateweaver 40 20 20 50.00% 1.36% 34.50%
Etienne 379 149 230 39.31% 12.87% 34.40%
Adora 29 15 14 51.72% 0.99% 33.54%
PatFusty_Snowman 34 17 17 50.00% 1.15% 33.19%
Gwendolin 40 13 27 32.50% 1.36% 17.98%
Obyn_Ocean 33 11 22 33.33% 1.12% 17.25%
Gwendolin_Science 56 16 40 28.57% 1.90% 16.74%

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;