neo_highway_heroes (view)

23 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Churchill_Sentai 3115 1791 1324 57.50% 23.69% 55.76%
Benjamin 796 446 350 56.03% 6.05% 52.58%
Churchill 2118 1120 998 52.88% 16.11% 50.75%
Bonnie 1394 697 697 50.00% 10.60% 47.38%
Quincy 1056 524 532 49.62% 8.03% 46.61%
Jericho_StarCaptain 137 72 65 52.55% 1.04% 44.19%
Quincy_Cyber 801 380 421 47.44% 6.09% 43.98%
Etienne_Bee 578 264 314 45.67% 4.40% 41.61%
Adora 266 124 142 46.62% 2.02% 40.62%
PatFusty_Snowman 139 68 71 48.92% 1.06% 40.61%
Etienne 1310 555 755 42.37% 9.96% 39.69%
StrikerJones 96 46 50 47.92% 0.73% 37.92%
PatFusty 54 27 27 50.00% 0.41% 36.66%
StrikerJones_Biker 82 36 46 43.90% 0.62% 33.16%
Jericho_Highwayman 105 43 62 40.95% 0.80% 31.55%
Adora_Fateweaver 78 33 45 42.31% 0.59% 31.34%
Jericho 332 119 213 35.84% 2.53% 30.69%
Gwendolin 173 63 110 36.42% 1.32% 29.25%
Gwendolin_Science 153 55 98 35.95% 1.16% 28.34%
Ezili_SmudgeCat 42 17 25 40.48% 0.32% 25.63%
Obyn_Ocean 65 23 42 35.38% 0.49% 23.76%
Ezili 88 27 61 30.68% 0.67% 21.05%
Obyn 117 34 83 29.06% 0.89% 20.83%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW neo_highway_heroes AS 
WITH neo_highway AS
    (SELECT *
    FROM matches
    WHERE map = 'neo_highway')
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 neo_highway) * 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 neo_highway
                  UNION ALL
                  SELECT rHero             AS Hero,
                         NOT playerLeftWin AS Win
                  FROM neo_highway)
            GROUP BY Hero))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;