salmon_pool_heroes (view)

19 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Winrate, Pickrate, Winrate_LowerBound_95CI

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Churchill_Sentai 328 199 129 60.67% 9.94% 55.38%
Bonnie 846 468 378 55.32% 25.64% 51.97%
Adora 123 74 49 60.16% 3.73% 51.51%
Benjamin 147 85 62 57.82% 4.45% 49.84%
Churchill 270 142 128 52.59% 8.18% 46.64%
Ezili 58 34 24 58.62% 1.76% 45.95%
Etienne_Bee 177 88 89 49.72% 5.36% 42.35%
Obyn 108 55 53 50.93% 3.27% 41.50%
PatFusty_Snowman 70 37 33 52.86% 2.12% 41.16%
Quincy 223 106 117 47.53% 6.76% 40.98%
Jericho 135 59 76 43.70% 4.09% 35.34%
Etienne 415 157 258 37.83% 12.58% 33.17%
Quincy_Cyber 58 26 32 44.83% 1.76% 32.03%
Gwendolin 86 32 54 37.21% 2.61% 26.99%
Adora_Fateweaver 22 10 12 45.45% 0.67% 24.65%
Obyn_Ocean 22 10 12 45.45% 0.67% 24.65%
Jericho_Highwayman 26 11 15 42.31% 0.79% 23.32%
StrikerJones 28 10 18 35.71% 0.85% 17.97%
Gwendolin_Science 89 20 69 22.47% 2.70% 13.80%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW salmon_pool_heroes AS 
WITH salmon_pool AS
    (SELECT *
    FROM matches
    WHERE map = 'salmon_pool')
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 salmon_pool) * 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 salmon_pool
                  UNION ALL
                  SELECT rHero             AS Hero,
                         NOT playerLeftWin AS Win
                  FROM salmon_pool)
            GROUP BY Hero))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;