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 675 420 255 62.22% 7.64% 58.56%
Jericho 620 362 258 58.39% 7.02% 54.51%
Gwendolin_Science 1000 520 480 52.00% 11.31% 48.90%
Adora_Fateweaver 53 32 21 60.38% 0.60% 47.21%
Benjamin 399 202 197 50.63% 4.51% 45.72%
PatFusty 208 108 100 51.92% 2.35% 45.13%
Obyn 405 201 204 49.63% 4.58% 44.76%
Bonnie 941 451 490 47.93% 10.65% 44.74%
Adora 296 149 147 50.34% 3.35% 44.64%
Etienne_Bee 695 333 362 47.91% 7.86% 44.20%
Jericho_Highwayman 93 50 43 53.76% 1.05% 43.63%
Etienne 1303 601 702 46.12% 14.74% 43.42%
Jericho_StarCaptain 191 96 95 50.26% 2.16% 43.17%
Ezili 179 86 93 48.04% 2.03% 40.73%
Gwendolin 351 161 190 45.87% 3.97% 40.66%
Quincy 254 118 136 46.46% 2.87% 40.32%
Ezili_SmudgeCat 67 35 32 52.24% 0.76% 40.28%
Benjamin_DJ 241 110 131 45.64% 2.73% 39.35%
Quincy_Cyber 190 85 105 44.74% 2.15% 37.67%
Churchill 166 75 91 45.18% 1.88% 37.61%
Churchill_Sentai 164 74 90 45.12% 1.86% 37.51%
Obyn_Ocean 216 95 121 43.98% 2.44% 37.36%
StrikerJones 95 39 56 41.05% 1.07% 31.16%
StrikerJones_Biker 36 16 20 44.44% 0.41% 28.21%

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;