star_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Adora_Fateweaver 61 44 17 72.13% 0.85% 60.88%
PatFusty_Snowman 623 397 226 63.72% 8.72% 59.95%
Gwendolin_Science 677 349 328 51.55% 9.47% 47.79%
Etienne_Bee 466 241 225 51.72% 6.52% 47.18%
Obyn 409 211 198 51.59% 5.72% 46.75%
Etienne 989 480 509 48.53% 13.84% 45.42%
Ezili 159 84 75 52.83% 2.22% 45.07%
Benjamin 361 180 181 49.86% 5.05% 44.70%
Bonnie 773 370 403 47.87% 10.81% 44.34%
Jericho 561 271 290 48.31% 7.85% 44.17%
PatFusty 127 66 61 51.97% 1.78% 43.28%
Jericho_StarCaptain 88 46 42 52.27% 1.23% 41.84%
StrikerJones 119 60 59 50.42% 1.66% 41.44%
Quincy 350 163 187 46.57% 4.90% 41.35%
Quincy_Cyber 125 62 63 49.60% 1.75% 40.83%
Gwendolin 335 153 182 45.67% 4.69% 40.34%
Ezili_SmudgeCat 60 31 29 51.67% 0.84% 39.02%
Obyn_Ocean 136 64 72 47.06% 1.90% 38.67%
Jericho_Highwayman 74 37 37 50.00% 1.04% 38.61%
Churchill_Sentai 182 81 101 44.51% 2.55% 37.29%
Churchill 114 52 62 45.61% 1.59% 36.47%
Adora 234 99 135 42.31% 3.27% 35.98%
StrikerJones_Biker 57 19 38 33.33% 0.80% 21.10%
Benjamin_DJ 68 14 54 20.59% 0.95% 10.98%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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