salmon_pool_heroes (view)

20 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses, Winrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Churchill_Sentai 281 183 98 65.12% 7.91% 59.55%
Adora 124 70 54 56.45% 3.49% 47.72%
Obyn 169 93 76 55.03% 4.76% 47.53%
Bonnie 861 437 424 50.75% 24.23% 47.42%
Churchill 252 134 118 53.17% 7.09% 47.01%
Jericho 155 85 70 54.84% 4.36% 47.00%
Quincy 179 95 84 53.07% 5.04% 45.76%
Ezili 84 45 39 53.57% 2.36% 42.91%
Etienne 586 261 325 44.54% 16.49% 40.52%
PatFusty_Snowman 47 25 22 53.19% 1.32% 38.93%
PatFusty 39 21 18 53.85% 1.10% 38.20%
Jericho_StarCaptain 45 23 22 51.11% 1.27% 36.51%
Etienne_Bee 306 127 179 41.50% 8.61% 35.98%
Obyn_Ocean 28 15 13 53.57% 0.79% 35.10%
Adora_Fateweaver 26 14 12 53.85% 0.73% 34.68%
Benjamin_DJ 22 12 10 54.55% 0.62% 33.74%
Gwendolin_Science 99 41 58 41.41% 2.79% 31.71%
Quincy_Cyber 52 22 30 42.31% 1.46% 28.88%
Gwendolin 67 26 41 38.81% 1.89% 27.14%
Benjamin 76 25 51 32.89% 2.14% 22.33%

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;