salmon_pool_heroes (view)

21 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Losses, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Benjamin_DJ 63 42 21 66.67% 1.58% 55.03%
Churchill_Sentai 386 231 155 59.84% 9.65% 54.95%
Bonnie 985 523 462 53.10% 24.64% 49.98%
Benjamin 155 86 69 55.48% 3.88% 47.66%
Adora 166 91 75 54.82% 4.15% 47.25%
StrikerJones 32 20 12 62.50% 0.80% 45.73%
Jericho 217 111 106 51.15% 5.43% 44.50%
Churchill 287 140 147 48.78% 7.18% 43.00%
Obyn 135 69 66 51.11% 3.38% 42.68%
Etienne 526 243 283 46.20% 13.16% 41.94%
Quincy 193 88 105 45.60% 4.83% 38.57%
PatFusty 23 13 10 56.52% 0.58% 36.26%
Adora_Fateweaver 30 16 14 53.33% 0.75% 35.48%
Etienne_Bee 228 94 134 41.23% 5.70% 34.84%
Jericho_StarCaptain 59 28 31 47.46% 1.48% 34.72%
Quincy_Cyber 116 50 66 43.10% 2.90% 34.09%
Ezili 73 33 40 45.21% 1.83% 33.79%
PatFusty_Snowman 63 26 37 41.27% 1.58% 29.11%
Gwendolin_Science 99 37 62 37.37% 2.48% 27.84%
Obyn_Ocean 30 12 18 40.00% 0.75% 22.47%
Gwendolin 76 24 52 31.58% 1.90% 21.13%

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;