salmon_pool_heroes (view)

18 rows

✎ View and edit SQL

This data as json, CSV (advanced)

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

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Benjamin 157 93 64 59.24% 5.04% 51.55%
Bonnie 594 327 267 55.05% 19.05% 51.05%
Quincy_Cyber 384 211 173 54.95% 12.32% 49.97%
Churchill_Sentai 556 278 278 50.00% 17.83% 45.84%
Quincy 218 110 108 50.46% 6.99% 43.82%
Obyn 85 46 39 54.12% 2.73% 43.52%
Etienne 346 165 181 47.69% 11.10% 42.42%
Jericho 55 29 26 52.73% 1.76% 39.53%
Churchill 216 95 121 43.98% 6.93% 37.36%
StrikerJones_Biker 64 29 35 45.31% 2.05% 33.12%
Etienne_Bee 97 41 56 42.27% 3.11% 32.44%
StrikerJones 31 15 16 48.39% 0.99% 30.79%
Jericho_Highwayman 26 13 13 50.00% 0.83% 30.78%
Adora 47 21 26 44.68% 1.51% 30.47%
Obyn_Ocean 32 15 17 46.88% 1.03% 29.58%
Ezili 31 13 18 41.94% 0.99% 24.56%
Gwendolin 37 14 23 37.84% 1.19% 22.21%
PatFusty 36 12 24 33.33% 1.15% 17.93%

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;