oasis_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 2737 1662 1075 60.72% 4.56% 58.89%
Jericho 4507 2594 1913 57.55% 7.51% 56.11%
Ezili 1803 991 812 54.96% 3.01% 52.67%
Churchill_Sentai 3536 1879 1657 53.14% 5.89% 51.49%
StrikerJones 884 483 401 54.64% 1.47% 51.36%
Obyn 5199 2725 2474 52.41% 8.67% 51.06%
Etienne_Bee 5104 2617 2487 51.27% 8.51% 49.90%
Jericho_StarCaptain 931 489 442 52.52% 1.55% 49.32%
Quincy_Cyber 2635 1343 1292 50.97% 4.39% 49.06%
StrikerJones_Biker 929 470 459 50.59% 1.55% 47.38%
Jericho_Highwayman 774 390 384 50.39% 1.29% 46.87%
Etienne 8654 4115 4539 47.55% 14.42% 46.50%
Churchill 2066 987 1079 47.77% 3.44% 45.62%
Benjamin 1693 811 882 47.90% 2.82% 45.52%
Bonnie 5813 2691 3122 46.29% 9.69% 45.01%
Adora 1487 703 784 47.28% 2.48% 44.74%
Quincy 2931 1347 1584 45.96% 4.89% 44.15%
Adora_Fateweaver 321 158 163 49.22% 0.54% 43.75%
Gwendolin_Science 3119 1414 1705 45.34% 5.20% 43.59%
Obyn_Ocean 1825 805 1020 44.11% 3.04% 41.83%
Ezili_SmudgeCat 440 204 236 46.36% 0.73% 41.70%
Gwendolin 1547 671 876 43.37% 2.58% 40.90%
PatFusty 635 269 366 42.36% 1.06% 38.52%
Benjamin_DJ 430 182 248 42.33% 0.72% 37.66%

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;