precious_space_heroes (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Losses, Winrate, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Adora 233 139 94 59.66% 5.52% 53.36%
Quincy 254 150 104 59.06% 6.02% 53.01%
Ezili_SmudgeCat 62 40 22 64.52% 1.47% 52.61%
Jericho_Highwayman 123 72 51 58.54% 2.91% 49.83%
PatFusty_Snowman 62 38 24 61.29% 1.47% 49.17%
Obyn 320 173 147 54.06% 7.58% 48.60%
Jericho 261 142 119 54.41% 6.18% 48.36%
Adora_Fateweaver 100 57 43 57.00% 2.37% 47.30%
Bonnie 713 347 366 48.67% 16.89% 45.00%
Etienne 807 386 421 47.83% 19.11% 44.38%
Jericho_StarCaptain 81 44 37 54.32% 1.92% 43.47%
Obyn_Ocean 44 25 19 56.82% 1.04% 42.18%
Gwendolin 108 55 53 50.93% 2.56% 41.50%
Etienne_Bee 423 191 232 45.15% 10.02% 40.41%
Benjamin_DJ 34 19 15 55.88% 0.81% 39.19%
Quincy_Cyber 69 33 36 47.83% 1.63% 36.04%
Ezili 85 39 46 45.88% 2.01% 35.29%
Benjamin 75 32 43 42.67% 1.78% 31.47%
StrikerJones_Biker 34 16 18 47.06% 0.81% 30.28%
Gwendolin_Science 174 62 112 35.63% 4.12% 28.52%
Churchill 64 24 40 37.50% 1.52% 25.64%
StrikerJones 40 13 27 32.50% 0.95% 17.98%

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;