precious_space_heroes (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho 506 327 179 64.62% 11.02% 60.46%
Quincy_Cyber 205 116 89 56.59% 4.47% 49.80%
Obyn 403 208 195 51.61% 8.78% 46.73%
Adora_Fateweaver 77 44 33 57.14% 1.68% 46.09%
Etienne 612 306 306 50.00% 13.33% 46.04%
Benjamin 256 132 124 51.56% 5.58% 45.44%
Bonnie 535 259 276 48.41% 11.66% 44.18%
Etienne_Bee 447 216 231 48.32% 9.74% 43.69%
Quincy 475 222 253 46.74% 10.35% 42.25%
Jericho_Highwayman 151 75 76 49.67% 3.29% 41.69%
Ezili_SmudgeCat 27 15 12 55.56% 0.59% 36.81%
Jericho_StarCaptain 115 52 63 45.22% 2.51% 36.12%
Adora 128 56 72 43.75% 2.79% 35.16%
Ezili 78 36 42 46.15% 1.70% 35.09%
PatFusty_Snowman 58 27 31 46.55% 1.26% 33.71%
Obyn_Ocean 69 31 38 44.93% 1.50% 33.19%
StrikerJones 45 21 24 46.67% 0.98% 32.09%
Churchill 69 30 39 43.48% 1.50% 31.78%
Gwendolin 81 34 47 41.98% 1.76% 31.23%
Benjamin_DJ 27 12 15 44.44% 0.59% 25.70%
Gwendolin_Science 107 37 70 34.58% 2.33% 25.57%
Churchill_Sentai 87 26 61 29.89% 1.90% 20.27%

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;