oasis_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Winrate, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 471 286 185 60.72% 5.86% 56.31%
Jericho 633 372 261 58.77% 7.87% 54.93%
Etienne_Bee 681 362 319 53.16% 8.47% 49.41%
Churchill_Sentai 264 144 120 54.55% 3.28% 48.54%
Etienne 1347 670 677 49.74% 16.75% 47.07%
Ezili 229 118 111 51.53% 2.85% 45.06%
Benjamin_DJ 131 70 61 53.44% 1.63% 44.89%
StrikerJones 107 58 49 54.21% 1.33% 44.77%
Obyn 561 271 290 48.31% 6.98% 44.17%
Churchill 264 132 132 50.00% 3.28% 43.97%
Adora 240 119 121 49.58% 2.98% 43.26%
Jericho_StarCaptain 215 107 108 49.77% 2.67% 43.08%
Bonnie 909 414 495 45.54% 11.30% 42.31%
Gwendolin_Science 526 244 282 46.39% 6.54% 42.13%
Jericho_Highwayman 96 49 47 51.04% 1.19% 41.04%
Gwendolin 194 90 104 46.39% 2.41% 39.37%
Obyn_Ocean 291 130 161 44.67% 3.62% 38.96%
Quincy_Cyber 192 87 105 45.31% 2.39% 38.27%
Quincy 236 102 134 43.22% 2.93% 36.90%
Benjamin 251 106 145 42.23% 3.12% 36.12%
Ezili_SmudgeCat 37 19 18 51.35% 0.46% 35.25%
PatFusty 88 36 52 40.91% 1.09% 30.64%
Adora_Fateweaver 43 19 24 44.19% 0.53% 29.34%
StrikerJones_Biker 36 16 20 44.44% 0.45% 28.21%

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;