oasis_heroes (view)

23 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 232 140 92 60.34% 3.16% 54.05%
Etienne_Bee 621 353 268 56.84% 8.46% 52.95%
Jericho 511 291 220 56.95% 6.96% 52.65%
Churchill_Sentai 685 375 310 54.74% 9.33% 51.02%
Jericho_StarCaptain 117 69 48 58.97% 1.59% 50.06%
Obyn 522 273 249 52.30% 7.11% 48.01%
Benjamin 310 166 144 53.55% 4.22% 48.00%
Quincy_Cyber 656 329 327 50.15% 8.94% 46.33%
StrikerJones_Biker 362 184 178 50.83% 4.93% 45.68%
Adora 156 80 76 51.28% 2.13% 43.44%
Bonnie 534 252 282 47.19% 7.28% 42.96%
Etienne 769 344 425 44.73% 10.48% 41.22%
Quincy 389 179 210 46.02% 5.30% 41.06%
StrikerJones 156 76 80 48.72% 2.13% 40.87%
Ezili 152 74 78 48.68% 2.07% 40.74%
Jericho_Highwayman 101 49 52 48.51% 1.38% 38.77%
Adora_Fateweaver 52 27 25 51.92% 0.71% 38.34%
Churchill 311 130 181 41.80% 4.24% 36.32%
Gwendolin_Science 185 78 107 42.16% 2.52% 35.05%
Gwendolin 141 57 84 40.43% 1.92% 32.33%
Obyn_Ocean 197 76 121 38.58% 2.68% 31.78%
PatFusty 116 44 72 37.93% 1.58% 29.10%
Ezili_SmudgeCat 34 15 19 44.12% 0.46% 27.43%

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;