star_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 638 368 270 57.68% 7.51% 53.85%
Quincy_Cyber 262 150 112 57.25% 3.08% 51.26%
Jericho_Highwayman 108 64 44 59.26% 1.27% 49.99%
Jericho 557 299 258 53.68% 6.55% 49.54%
Etienne_Bee 993 521 472 52.47% 11.68% 49.36%
Churchill_Sentai 447 233 214 52.13% 5.26% 47.49%
Ezili 270 143 127 52.96% 3.18% 47.01%
Gwendolin_Science 754 379 375 50.27% 8.87% 46.70%
Quincy 627 314 313 50.08% 7.38% 46.17%
Bonnie 660 316 344 47.88% 7.76% 44.07%
Adora_Fateweaver 75 41 34 54.67% 0.88% 43.40%
Etienne 886 410 476 46.28% 10.42% 42.99%
Obyn 491 232 259 47.25% 5.78% 42.83%
Adora 169 84 85 49.70% 1.99% 42.17%
Benjamin 355 159 196 44.79% 4.18% 39.62%
Churchill 217 100 117 46.08% 2.55% 39.45%
StrikerJones 90 44 46 48.89% 1.06% 38.56%
Jericho_StarCaptain 118 56 62 47.46% 1.39% 38.45%
Obyn_Ocean 184 83 101 45.11% 2.16% 37.92%
Ezili_SmudgeCat 58 29 29 50.00% 0.68% 37.13%
Gwendolin 357 149 208 41.74% 4.20% 36.62%
StrikerJones_Biker 59 27 32 45.76% 0.69% 33.05%
PatFusty 92 38 54 41.30% 1.08% 31.24%
Benjamin_DJ 33 11 22 33.33% 0.39% 17.25%

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;