dino_graveyard_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho 5202 3317 1885 63.76% 10.16% 62.46%
PatFusty_Snowman 1275 750 525 58.82% 2.49% 56.12%
Obyn 3774 2116 1658 56.07% 7.37% 54.48%
Jericho_Highwayman 885 494 391 55.82% 1.73% 52.55%
StrikerJones_Biker 1259 678 581 53.85% 2.46% 51.10%
Ezili 1199 628 571 52.38% 2.34% 49.55%
Jericho_StarCaptain 691 364 327 52.68% 1.35% 48.95%
Quincy_Cyber 2283 1154 1129 50.55% 4.46% 48.50%
Etienne_Bee 4048 1986 2062 49.06% 7.91% 47.52%
Bonnie 6727 3227 3500 47.97% 13.14% 46.78%
Ezili_SmudgeCat 376 191 185 50.80% 0.73% 45.74%
PatFusty 553 276 277 49.91% 1.08% 45.74%
Quincy 2579 1221 1358 47.34% 5.04% 45.42%
Churchill_Sentai 1976 940 1036 47.57% 3.86% 45.37%
Adora 1459 691 768 47.36% 2.85% 44.80%
Benjamin 2530 1164 1366 46.01% 4.94% 44.07%
Etienne 6548 2960 3588 45.20% 12.79% 44.00%
Gwendolin_Science 2444 1089 1355 44.56% 4.78% 42.59%
Gwendolin 1601 718 883 44.85% 3.13% 42.41%
StrikerJones 520 241 279 46.35% 1.02% 42.06%
Obyn_Ocean 1180 525 655 44.49% 2.31% 41.66%
Adora_Fateweaver 312 147 165 47.12% 0.61% 41.58%
Benjamin_DJ 525 229 296 43.62% 1.03% 39.38%
Churchill 1232 483 749 39.20% 2.41% 36.48%

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;