dino_graveyard_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Pickrate, Winrate_LowerBound_95CI

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho 766 477 289 62.27% 12.91% 58.84%
Obyn 374 221 153 59.09% 6.30% 54.11%
StrikerJones_Biker 285 157 128 55.09% 4.80% 49.31%
Ezili 155 85 70 54.84% 2.61% 47.00%
Benjamin 362 187 175 51.66% 6.10% 46.51%
Churchill_Sentai 319 164 155 51.41% 5.38% 45.93%
Etienne_Bee 575 285 290 49.57% 9.69% 45.48%
Quincy_Cyber 491 245 246 49.90% 8.27% 45.48%
Quincy 335 162 173 48.36% 5.65% 43.01%
PatFusty_Snowman 121 62 59 51.24% 2.04% 42.33%
Bonnie 498 229 269 45.98% 8.39% 41.61%
Adora_Fateweaver 29 17 12 58.62% 0.49% 40.70%
Etienne 502 218 284 43.43% 8.46% 39.09%
Jericho_StarCaptain 61 30 31 49.18% 1.03% 36.63%
Obyn_Ocean 159 69 90 43.40% 2.68% 35.69%
Gwendolin 186 79 107 42.47% 3.13% 35.37%
PatFusty 75 34 41 45.33% 1.26% 34.07%
Jericho_Highwayman 86 38 48 44.19% 1.45% 33.69%
Adora 120 51 69 42.50% 2.02% 33.66%
Churchill 124 47 77 37.90% 2.09% 29.36%
Gwendolin_Science 155 57 98 36.77% 2.61% 29.18%
StrikerJones 81 27 54 33.33% 1.37% 23.07%
Ezili_SmudgeCat 25 10 15 40.00% 0.42% 20.80%
Benjamin_DJ 50 16 34 32.00% 0.84% 19.07%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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