precious_space_heroes (view)

21 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 516 310 206 60.08% 12.51% 55.85%
Obyn 133 80 53 60.15% 3.23% 51.83%
Quincy_Cyber 697 375 322 53.80% 16.90% 50.10%
StrikerJones_Biker 100 58 42 58.00% 2.42% 48.33%
Bonnie 332 171 161 51.51% 8.05% 46.13%
Jericho 308 155 153 50.32% 7.47% 44.74%
Jericho_Highwayman 232 117 115 50.43% 5.63% 44.00%
Quincy 351 168 183 47.86% 8.51% 42.64%
Etienne_Bee 275 129 146 46.91% 6.67% 41.01%
Etienne 467 199 268 42.61% 11.32% 38.13%
Adora 70 33 37 47.14% 1.70% 35.45%
Jericho_StarCaptain 74 34 40 45.95% 1.79% 34.59%
Adora_Fateweaver 43 21 22 48.84% 1.04% 33.90%
Churchill_Sentai 61 28 33 45.90% 1.48% 33.40%
Ezili 76 33 43 43.42% 1.84% 32.28%
Gwendolin 70 30 40 42.86% 1.70% 31.26%
StrikerJones 49 21 28 42.86% 1.19% 29.00%
Churchill 87 33 54 37.93% 2.11% 27.74%
Gwendolin_Science 39 16 23 41.03% 0.95% 25.59%
Obyn_Ocean 60 20 40 33.33% 1.45% 21.41%
PatFusty 43 13 30 30.23% 1.04% 16.51%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW precious_space_heroes AS 
WITH precious_space AS
    (SELECT *
    FROM matches
    WHERE map = 'precious_space')
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 precious_space) * 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 precious_space
                  UNION ALL
                  SELECT rHero             AS Hero,
                         NOT playerLeftWin AS Win
                  FROM precious_space)
            GROUP BY Hero))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;