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
Gwendolin_Science 359 215 144 59.89% 11.53% 54.82%
Jericho_Highwayman 48 30 18 62.50% 1.54% 48.80%
Jericho 174 97 77 55.75% 5.59% 48.37%
PatFusty_Snowman 63 38 25 60.32% 2.02% 48.24%
Etienne_Bee 283 152 131 53.71% 9.09% 47.90%
Benjamin 75 42 33 56.00% 2.41% 44.77%
Quincy 300 146 154 48.67% 9.63% 43.01%
Bonnie 334 161 173 48.20% 10.73% 42.84%
Etienne 485 226 259 46.60% 15.57% 42.16%
StrikerJones 43 23 20 53.49% 1.38% 38.58%
Quincy_Cyber 118 56 62 47.46% 3.79% 38.45%
Ezili 88 43 45 48.86% 2.83% 38.42%
Churchill 84 41 43 48.81% 2.70% 38.12%
Gwendolin 177 80 97 45.20% 5.68% 37.87%
StrikerJones_Biker 35 19 16 54.29% 1.12% 37.78%
Ezili_SmudgeCat 29 15 14 51.72% 0.93% 33.54%
Churchill_Sentai 77 34 43 44.16% 2.47% 33.06%
Jericho_StarCaptain 43 20 23 46.51% 1.38% 31.60%
Obyn 69 29 40 42.03% 2.22% 30.38%
Obyn_Ocean 68 28 40 41.18% 2.18% 29.48%
Adora_Fateweaver 25 12 13 48.00% 0.80% 28.42%
PatFusty 42 17 25 40.48% 1.35% 25.63%
Adora 81 29 52 35.80% 2.60% 25.36%

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;