oasis_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Losses, Winrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho 761 453 308 59.53% 10.97% 56.04%
Jericho_StarCaptain 79 50 29 63.29% 1.14% 52.66%
Churchill_Sentai 639 348 291 54.46% 9.22% 50.60%
PatFusty_Snowman 331 181 150 54.68% 4.77% 49.32%
Obyn 426 225 201 52.82% 6.14% 48.08%
Etienne_Bee 712 365 347 51.26% 10.27% 47.59%
Benjamin 199 108 91 54.27% 2.87% 47.35%
Quincy_Cyber 531 264 267 49.72% 7.66% 45.46%
Ezili 193 101 92 52.33% 2.78% 45.29%
StrikerJones_Biker 230 116 114 50.43% 3.32% 43.97%
Churchill 213 107 106 50.23% 3.07% 43.52%
Bonnie 434 206 228 47.47% 6.26% 42.77%
PatFusty 81 43 38 53.09% 1.17% 42.22%
StrikerJones 125 63 62 50.40% 1.80% 41.63%
Etienne 655 291 364 44.43% 9.45% 40.62%
Quincy 359 161 198 44.85% 5.18% 39.70%
Ezili_SmudgeCat 48 24 24 50.00% 0.69% 35.85%
Jericho_Highwayman 105 46 59 43.81% 1.51% 34.32%
Gwendolin_Science 200 82 118 41.00% 2.88% 34.18%
Adora_Fateweaver 34 17 17 50.00% 0.49% 33.19%
Obyn_Ocean 232 91 141 39.22% 3.35% 32.94%
Gwendolin 187 66 121 35.29% 2.70% 28.44%
Adora 121 44 77 36.36% 1.75% 27.79%
Benjamin_DJ 39 15 24 38.46% 0.56% 23.19%

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;