banana_depot_scene_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho_Highwayman 686 416 270 60.64% 3.08% 56.99%
StrikerJones 642 389 253 60.59% 2.89% 56.81%
Quincy_Cyber 1892 1070 822 56.55% 8.50% 54.32%
Jericho_StarCaptain 581 334 247 57.49% 2.61% 53.47%
Adora_Fateweaver 412 238 174 57.77% 1.85% 53.00%
Jericho 1813 985 828 54.33% 8.15% 52.04%
Etienne_Bee 2980 1599 1381 53.66% 13.39% 51.87%
Ezili 808 430 378 53.22% 3.63% 49.78%
PatFusty_Snowman 583 304 279 52.14% 2.62% 48.09%
Quincy 1705 853 852 50.03% 7.66% 47.66%
Benjamin 377 196 181 51.99% 1.69% 46.95%
Etienne 4927 2333 2594 47.35% 22.15% 45.96%
Adora 446 225 221 50.45% 2.00% 45.81%
Bonnie 1470 689 781 46.87% 6.61% 44.32%
StrikerJones_Biker 249 124 125 49.80% 1.12% 43.59%
Ezili_SmudgeCat 134 62 72 46.27% 0.60% 37.83%
PatFusty 273 112 161 41.03% 1.23% 35.19%
Gwendolin_Science 773 270 503 34.93% 3.47% 31.57%
Gwendolin 614 217 397 35.34% 2.76% 31.56%
Obyn_Ocean 223 76 147 34.08% 1.00% 27.86%
Obyn 216 68 148 31.48% 0.97% 25.29%
Churchill_Sentai 193 61 132 31.61% 0.87% 25.05%
Churchill 181 54 127 29.83% 0.81% 23.17%
Benjamin_DJ 70 19 51 27.14% 0.31% 16.73%

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;