oasis_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Quincy_Cyber 294 177 117 60.20% 3.50% 54.61%
PatFusty_Snowman 432 250 182 57.87% 5.14% 53.21%
Obyn 1170 645 525 55.13% 13.91% 52.28%
StrikerJones 146 87 59 59.59% 1.74% 51.63%
Etienne_Bee 932 492 440 52.79% 11.08% 49.58%
Ezili 243 135 108 55.56% 2.89% 49.31%
Jericho 632 336 296 53.16% 7.51% 49.27%
Churchill_Sentai 417 215 202 51.56% 4.96% 46.76%
Etienne 920 433 487 47.07% 10.94% 43.84%
Quincy 592 282 310 47.64% 7.04% 43.61%
Jericho_StarCaptain 137 69 68 50.36% 1.63% 41.99%
Churchill 266 125 141 46.99% 3.16% 40.99%
Adora 157 75 82 47.77% 1.87% 39.96%
Benjamin 275 124 151 45.09% 3.27% 39.21%
Gwendolin_Science 383 169 214 44.13% 4.55% 39.15%
Bonnie 634 272 362 42.90% 7.54% 39.05%
Obyn_Ocean 257 106 151 41.25% 3.06% 35.23%
Jericho_Highwayman 92 41 51 44.57% 1.09% 34.41%
StrikerJones_Biker 70 32 38 45.71% 0.83% 34.04%
Gwendolin 180 73 107 40.56% 2.14% 33.38%
Adora_Fateweaver 38 17 21 44.74% 0.45% 28.93%
Ezili_SmudgeCat 57 21 36 36.84% 0.68% 24.32%
PatFusty 56 19 37 33.93% 0.67% 21.53%
Benjamin_DJ 30 10 20 33.33% 0.36% 16.46%

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;