oasis_heroes (view)

23 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho 685 400 285 58.39% 8.81% 54.70%
Ezili 219 130 89 59.36% 2.82% 52.86%
PatFusty_Snowman 270 157 113 58.15% 3.47% 52.26%
Quincy_Cyber 544 295 249 54.23% 6.99% 50.04%
Benjamin 157 90 67 57.32% 2.02% 49.59%
Obyn 804 421 383 52.36% 10.34% 48.91%
Churchill_Sentai 954 493 461 51.68% 12.27% 48.51%
StrikerJones 102 59 43 57.84% 1.31% 48.26%
Etienne_Bee 896 454 442 50.67% 11.52% 47.40%
Quincy 533 268 265 50.28% 6.85% 46.04%
Jericho_Highwayman 147 77 70 52.38% 1.89% 44.31%
Jericho_StarCaptain 67 37 30 55.22% 0.86% 43.32%
Churchill 303 147 156 48.51% 3.90% 42.89%
StrikerJones_Biker 46 26 20 56.52% 0.59% 42.20%
Gwendolin_Science 246 119 127 48.37% 3.16% 42.13%
Bonnie 497 202 295 40.64% 6.39% 36.33%
Etienne 663 259 404 39.06% 8.52% 35.35%
Gwendolin 143 62 81 43.36% 1.84% 35.23%
Obyn_Ocean 216 90 126 41.67% 2.78% 35.09%
Ezili_SmudgeCat 71 28 43 39.44% 0.91% 28.07%
PatFusty 32 14 18 43.75% 0.41% 26.56%
Adora_Fateweaver 24 11 13 45.83% 0.31% 25.90%
Adora 128 43 85 33.59% 1.65% 25.41%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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