mayan_map_01_heroes (view)

19 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Gwendolin_Science 341 202 139 59.24% 11.82% 54.02%
Etienne 576 303 273 52.60% 19.96% 48.53%
PatFusty_Snowman 48 28 20 58.33% 1.66% 44.39%
Churchill 94 51 43 54.26% 3.26% 44.18%
Jericho 114 60 54 52.63% 3.95% 43.47%
Etienne_Bee 380 182 198 47.89% 13.17% 42.87%
Quincy_Cyber 62 34 28 54.84% 2.15% 42.45%
Churchill_Sentai 32 19 13 59.38% 1.11% 42.36%
Quincy 122 62 60 50.82% 4.23% 41.95%
Jericho_StarCaptain 43 23 20 53.49% 1.49% 38.58%
Bonnie 436 186 250 42.66% 15.11% 38.02%
Ezili 60 30 30 50.00% 2.08% 37.35%
Adora 77 37 40 48.05% 2.67% 36.89%
PatFusty 70 34 36 48.57% 2.43% 36.86%
Obyn 81 38 43 46.91% 2.81% 36.05%
Gwendolin 148 64 84 43.24% 5.13% 35.26%
Obyn_Ocean 59 28 31 47.46% 2.04% 34.72%
Jericho_Highwayman 23 12 11 52.17% 0.80% 31.76%
Benjamin 41 12 29 29.27% 1.42% 15.34%

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;