mayan_map_01_heroes (view)

23 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 41 27 14 65.85% 1.46% 51.34%
Gwendolin_Science 243 135 108 55.56% 8.65% 49.31%
Quincy_Cyber 223 123 100 55.16% 7.94% 48.63%
Quincy 258 138 120 53.49% 9.18% 47.40%
Jericho 159 87 72 54.72% 5.66% 46.98%
Bonnie 257 135 122 52.53% 9.15% 46.42%
Obyn_Ocean 54 32 22 59.26% 1.92% 46.15%
Benjamin 114 61 53 53.51% 4.06% 44.35%
Etienne_Bee 190 95 95 50.00% 6.76% 42.89%
Jericho_StarCaptain 67 35 32 52.24% 2.38% 40.28%
Etienne 386 173 213 44.82% 13.74% 39.86%
Churchill_Sentai 89 44 45 49.44% 3.17% 39.05%
PatFusty 71 35 36 49.30% 2.53% 37.67%
Jericho_Highwayman 71 34 37 47.89% 2.53% 36.27%
StrikerJones_Biker 79 37 42 46.84% 2.81% 35.83%
Gwendolin 110 47 63 42.73% 3.91% 33.48%
Adora 97 42 55 43.30% 3.45% 33.44%
Ezili 46 22 24 47.83% 1.64% 33.39%
Churchill 92 38 54 41.30% 3.27% 31.24%
StrikerJones 51 21 30 41.18% 1.81% 27.67%
Obyn 49 20 29 40.82% 1.74% 27.05%
Adora_Fateweaver 28 12 16 42.86% 1.00% 24.53%
Ezili_SmudgeCat 26 10 16 38.46% 0.93% 19.76%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW mayan_map_01_heroes AS 
WITH mayan_map_01 AS
    (SELECT *
    FROM matches
    WHERE map = 'mayan_map_01')
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 mayan_map_01) * 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 mayan_map_01
                  UNION ALL
                  SELECT rHero             AS Hero,
                         NOT playerLeftWin AS Win
                  FROM mayan_map_01)
            GROUP BY Hero))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;