salmon_pool_heroes (view)

17 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Churchill_Sentai 1045 587 458 56.17% 28.34% 53.16%
Quincy 330 178 152 53.94% 8.95% 48.56%
Benjamin 83 49 34 59.04% 2.25% 48.46%
Jericho 133 75 58 56.39% 3.61% 47.96%
Bonnie 529 273 256 51.61% 14.34% 47.35%
Quincy_Cyber 286 144 142 50.35% 7.75% 44.55%
Adora 42 24 18 57.14% 1.14% 42.18%
Etienne_Bee 188 86 102 45.74% 5.10% 38.62%
Ezili 38 20 18 52.63% 1.03% 36.76%
Obyn 123 56 67 45.53% 3.34% 36.73%
Churchill 319 125 194 39.18% 8.65% 33.83%
Etienne 284 108 176 38.03% 7.70% 32.38%
Obyn_Ocean 29 14 15 48.28% 0.79% 30.09%
Gwendolin 59 24 35 40.68% 1.60% 28.14%
Gwendolin_Science 49 19 30 38.78% 1.33% 25.13%
Jericho_Highwayman 28 10 18 35.71% 0.76% 17.97%
PatFusty_Snowman 34 10 24 29.41% 0.92% 14.10%

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;