mayan_map_01_heroes (view)

21 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 194 115 79 59.28% 7.45% 52.36%
Jericho 186 108 78 58.06% 7.14% 50.97%
Churchill_Sentai 108 64 44 59.26% 4.15% 49.99%
Jericho_Highwayman 32 21 11 65.63% 1.23% 49.17%
Gwendolin_Science 238 130 108 54.62% 9.14% 48.30%
Quincy 223 116 107 52.02% 8.56% 45.46%
PatFusty_Snowman 83 46 37 55.42% 3.19% 44.73%
Jericho_StarCaptain 46 27 19 58.70% 1.77% 44.47%
Gwendolin 120 61 59 50.83% 4.61% 41.89%
Ezili 87 44 43 50.57% 3.34% 40.07%
Etienne 341 150 191 43.99% 13.10% 38.72%
Churchill 75 37 38 49.33% 2.88% 38.02%
Etienne_Bee 203 91 112 44.83% 7.80% 37.99%
Bonnie 211 94 117 44.55% 8.10% 37.84%
StrikerJones 35 19 16 54.29% 1.34% 37.78%
StrikerJones_Biker 59 28 31 47.46% 2.27% 34.72%
Adora 82 36 46 43.90% 3.15% 33.16%
Benjamin 76 33 43 43.42% 2.92% 32.28%
Obyn 51 22 29 43.14% 1.96% 29.54%
Obyn_Ocean 64 26 38 40.63% 2.46% 28.59%
PatFusty 40 16 24 40.00% 1.54% 24.82%

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;