oasis_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Losses, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 391 260 131 66.50% 5.28% 61.82%
Ezili_SmudgeCat 48 32 16 66.67% 0.65% 53.33%
Churchill_Sentai 176 105 71 59.66% 2.37% 52.41%
Jericho 376 212 164 56.38% 5.07% 51.37%
Jericho_Highwayman 78 47 31 60.26% 1.05% 49.40%
StrikerJones_Biker 64 38 26 59.38% 0.86% 47.34%
Etienne 1406 690 716 49.08% 18.97% 46.46%
Obyn 536 270 266 50.37% 7.23% 46.14%
Obyn_Ocean 232 120 112 51.72% 3.13% 45.29%
Adora 250 128 122 51.20% 3.37% 45.00%
Ezili 239 122 117 51.05% 3.22% 44.71%
Bonnie 793 380 413 47.92% 10.70% 44.44%
Churchill 260 131 129 50.38% 3.51% 44.31%
Gwendolin_Science 619 294 325 47.50% 8.35% 43.56%
Etienne_Bee 921 418 503 45.39% 12.43% 42.17%
Adora_Fateweaver 37 21 16 56.76% 0.50% 40.79%
Jericho_StarCaptain 115 57 58 49.57% 1.55% 40.43%
Gwendolin 206 95 111 46.12% 2.78% 39.31%
PatFusty 131 62 69 47.33% 1.77% 38.78%
Quincy_Cyber 120 55 65 45.83% 1.62% 36.92%
Quincy 244 102 142 41.80% 3.29% 35.61%
StrikerJones 52 23 29 44.23% 0.70% 30.73%
Benjamin_DJ 48 20 28 41.67% 0.65% 27.72%
Benjamin 70 24 46 34.29% 0.94% 23.17%

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;