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 3571 2168 1403 60.71% 5.53% 59.11%
Jericho 5141 3001 2140 58.37% 7.96% 57.03%
Adora_Fateweaver 456 253 203 55.48% 0.71% 50.92%
Quincy_Cyber 2682 1413 1269 52.68% 4.15% 50.79%
Gwendolin_Science 5752 2931 2821 50.96% 8.90% 49.66%
Ezili 1665 865 800 51.95% 2.58% 49.55%
Jericho_Highwayman 899 470 429 52.28% 1.39% 49.02%
Etienne_Bee 5038 2510 2528 49.82% 7.80% 48.44%
Jericho_StarCaptain 878 450 428 51.25% 1.36% 47.95%
PatFusty 1146 582 564 50.79% 1.77% 47.89%
Benjamin 2539 1256 1283 49.47% 3.93% 47.52%
Churchill_Sentai 3016 1477 1539 48.97% 4.67% 47.19%
Etienne 8441 4055 4386 48.04% 13.06% 46.97%
Obyn 3252 1574 1678 48.40% 5.03% 46.68%
Bonnie 6396 2991 3405 46.76% 9.90% 45.54%
Quincy 3373 1584 1789 46.96% 5.22% 45.28%
StrikerJones_Biker 896 433 463 48.33% 1.39% 45.05%
Ezili_SmudgeCat 533 262 271 49.16% 0.82% 44.91%
StrikerJones 758 365 393 48.15% 1.17% 44.60%
Adora 1792 817 975 45.59% 2.77% 43.29%
Gwendolin 2721 1221 1500 44.87% 4.21% 43.00%
Churchill 1611 722 889 44.82% 2.49% 42.39%
Benjamin_DJ 767 346 421 45.11% 1.19% 41.59%
Obyn_Ocean 1301 566 735 43.50% 2.01% 40.81%

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;