salmon_pool_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Churchill_Sentai 4211 2422 1789 57.52% 15.08% 56.02%
Adora 735 410 325 55.78% 2.63% 52.19%
Benjamin 893 493 400 55.21% 3.20% 51.95%
Bonnie 6072 3222 2850 53.06% 21.75% 51.81%
Adora_Fateweaver 164 94 70 57.32% 0.59% 49.75%
Quincy_Cyber 1417 726 691 51.24% 5.08% 48.63%
Quincy 1940 973 967 50.15% 6.95% 47.93%
Ezili 490 255 235 52.04% 1.76% 47.62%
Obyn 884 440 444 49.77% 3.17% 46.48%
Jericho 1103 545 558 49.41% 3.95% 46.46%
Benjamin_DJ 178 95 83 53.37% 0.64% 46.04%
Churchill 2242 1069 1173 47.68% 8.03% 45.61%
Jericho_StarCaptain 242 117 125 48.35% 0.87% 42.05%
Etienne 3460 1489 1971 43.03% 12.39% 41.38%
PatFusty_Snowman 308 143 165 46.43% 1.10% 40.86%
Etienne_Bee 1294 554 740 42.81% 4.63% 40.12%
StrikerJones 178 84 94 47.19% 0.64% 39.86%
StrikerJones_Biker 155 73 82 47.10% 0.56% 39.24%
Obyn_Ocean 223 97 126 43.50% 0.80% 36.99%
Gwendolin 571 225 346 39.40% 2.05% 35.40%
PatFusty 214 89 125 41.59% 0.77% 34.99%
Jericho_Highwayman 211 85 126 40.28% 0.76% 33.67%
Ezili_SmudgeCat 115 46 69 40.00% 0.41% 31.05%
Gwendolin_Science 620 214 406 34.52% 2.22% 30.77%

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;