star_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Losses, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 326 208 118 63.80% 4.16% 58.59%
Jericho 689 394 295 57.18% 8.80% 53.49%
Quincy_Cyber 751 424 327 56.46% 9.59% 52.91%
Etienne_Bee 576 317 259 55.03% 7.36% 50.97%
Benjamin 469 260 209 55.44% 5.99% 50.94%
Ezili 152 84 68 55.26% 1.94% 47.36%
StrikerJones_Biker 369 191 178 51.76% 4.71% 46.66%
Gwendolin_Science 392 199 193 50.77% 5.01% 45.82%
Churchill_Sentai 463 226 237 48.81% 5.91% 44.26%
Quincy 463 220 243 47.52% 5.91% 42.97%
Etienne 788 351 437 44.54% 10.06% 41.07%
Obyn 286 132 154 46.15% 3.65% 40.38%
Jericho_Highwayman 138 66 72 47.83% 1.76% 39.49%
PatFusty 218 100 118 45.87% 2.78% 39.26%
Bonnie 529 230 299 43.48% 6.76% 39.25%
Jericho_StarCaptain 97 46 51 47.42% 1.24% 37.49%
Gwendolin 203 88 115 43.35% 2.59% 36.53%
Churchill 297 123 174 41.41% 3.79% 35.81%
StrikerJones 145 63 82 43.45% 1.85% 35.38%
Adora 182 75 107 41.21% 2.32% 34.06%
Obyn_Ocean 145 59 86 40.69% 1.85% 32.69%
Ezili_SmudgeCat 47 22 25 46.81% 0.60% 32.54%
Adora_Fateweaver 69 26 43 37.68% 0.88% 26.25%
Benjamin_DJ 36 11 25 30.56% 0.46% 15.51%

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;