star_heroes (view)

23 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Winrate_LowerBound_95CI

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho 390 250 140 64.10% 4.62% 59.34%
PatFusty_Snowman 464 279 185 60.13% 5.50% 55.67%
PatFusty 212 124 88 58.49% 2.51% 51.86%
Benjamin_DJ 140 83 57 59.29% 1.66% 51.15%
Etienne 1483 761 722 51.31% 17.58% 48.77%
Gwendolin_Science 1062 525 537 49.44% 12.59% 46.43%
Bonnie 1061 519 542 48.92% 12.58% 45.91%
Adora 283 144 139 50.88% 3.36% 45.06%
Ezili 203 104 99 51.23% 2.41% 44.36%
Churchill 152 77 75 50.66% 1.80% 42.71%
StrikerJones_Biker 70 38 32 54.29% 0.83% 42.62%
Obyn 513 238 275 46.39% 6.08% 42.08%
Jericho_Highwayman 61 33 28 54.10% 0.72% 41.59%
Etienne_Bee 958 417 541 43.53% 11.36% 40.39%
Ezili_SmudgeCat 69 36 33 52.17% 0.82% 40.39%
Jericho_StarCaptain 97 48 49 49.48% 1.15% 39.53%
Quincy_Cyber 114 55 59 48.25% 1.35% 39.07%
StrikerJones 56 29 27 51.79% 0.66% 38.70%
Gwendolin 366 154 212 42.08% 4.34% 37.02%
Churchill_Sentai 94 44 50 46.81% 1.11% 36.72%
Quincy 262 109 153 41.60% 3.11% 35.63%
Obyn_Ocean 165 71 94 43.03% 1.96% 35.48%
Benjamin 127 54 73 42.52% 1.51% 33.92%

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;