oasis_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 498 297 201 59.64% 7.23% 55.33%
Jericho 549 313 236 57.01% 7.97% 52.87%
Obyn 707 386 321 54.60% 10.26% 50.93%
Jericho_Highwayman 71 44 27 61.97% 1.03% 50.68%
Ezili 226 123 103 54.42% 3.28% 47.93%
StrikerJones 100 57 43 57.00% 1.45% 47.30%
Etienne_Bee 436 218 218 50.00% 6.33% 45.31%
Churchill_Sentai 258 132 126 51.16% 3.75% 45.06%
Gwendolin 201 104 97 51.74% 2.92% 44.83%
Etienne 1073 502 571 46.78% 15.58% 43.80%
Benjamin 263 131 132 49.81% 3.82% 43.77%
Bonnie 698 319 379 45.70% 10.13% 42.01%
Quincy 328 153 175 46.65% 4.76% 41.25%
Gwendolin_Science 386 177 209 45.85% 5.60% 40.88%
Jericho_StarCaptain 116 57 59 49.14% 1.68% 40.04%
Churchill 190 89 101 46.84% 2.76% 39.75%
Adora_Fateweaver 44 23 21 52.27% 0.64% 37.51%
Obyn_Ocean 181 79 102 43.65% 2.63% 36.42%
Adora 159 70 89 44.03% 2.31% 36.31%
Quincy_Cyber 145 64 81 44.14% 2.11% 36.06%
PatFusty 96 43 53 44.79% 1.39% 34.84%
Ezili_SmudgeCat 30 14 16 46.67% 0.44% 28.81%
StrikerJones_Biker 87 33 54 37.93% 1.26% 27.74%
Benjamin_DJ 46 16 30 34.78% 0.67% 21.02%

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;