precious_space_heroes (view)

19 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Adora_Fateweaver 78 53 25 67.95% 1.69% 57.59%
Jericho 578 339 239 58.65% 12.52% 54.64%
Jericho_Highwayman 356 212 144 59.55% 7.71% 54.45%
Quincy 529 289 240 54.63% 11.46% 50.39%
Etienne_Bee 537 287 250 53.45% 11.63% 49.23%
Quincy_Cyber 551 280 271 50.82% 11.94% 46.64%
Obyn 291 150 141 51.55% 6.30% 45.80%
StrikerJones 39 23 16 58.97% 0.84% 43.54%
Bonnie 381 176 205 46.19% 8.25% 41.19%
Gwendolin 81 42 39 51.85% 1.75% 40.97%
Benjamin 158 77 81 48.73% 3.42% 40.94%
Etienne 428 176 252 41.12% 9.27% 36.46%
Jericho_StarCaptain 73 32 41 43.84% 1.58% 32.45%
Ezili 79 33 46 41.77% 1.71% 30.90%
Churchill_Sentai 116 39 77 33.62% 2.51% 25.02%
PatFusty 23 10 13 43.48% 0.50% 23.22%
Adora 69 23 46 33.33% 1.49% 22.21%
PatFusty_Snowman 43 14 29 32.56% 0.93% 18.55%
Gwendolin_Science 57 17 40 29.82% 1.23% 17.95%

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;