oasis_heroes (view)

21 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Winrate, Pickrate, Winrate_LowerBound_95CI

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 112 78 34 69.64% 6.04% 61.13%
Jericho 162 93 69 57.41% 8.74% 49.79%
Obyn 131 72 59 54.96% 7.07% 46.44%
Etienne_Bee 176 92 84 52.27% 9.49% 44.89%
Churchill_Sentai 131 69 62 52.67% 7.07% 44.12%
Quincy_Cyber 152 76 76 50.00% 8.20% 42.05%
Bonnie 148 71 77 47.97% 7.98% 39.92%
Ezili 51 26 25 50.98% 2.75% 37.26%
StrikerJones_Biker 34 18 16 52.94% 1.83% 36.16%
Obyn_Ocean 57 28 29 49.12% 3.07% 36.14%
Adora 32 17 15 53.13% 1.73% 35.83%
Jericho_Highwayman 28 15 13 53.57% 1.51% 35.10%
Etienne 174 73 101 41.95% 9.39% 34.62%
Quincy 80 35 45 43.75% 4.31% 32.88%
Benjamin 123 50 73 40.65% 6.63% 31.97%
Jericho_StarCaptain 23 12 11 52.17% 1.24% 31.76%
Ezili_SmudgeCat 38 18 20 47.37% 2.05% 31.49%
Gwendolin 28 14 14 50.00% 1.51% 31.48%
StrikerJones 28 14 14 50.00% 1.51% 31.48%
Churchill 68 26 42 38.24% 3.67% 26.68%
Gwendolin_Science 56 22 34 39.29% 3.02% 26.49%

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;