koru_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Adora_Fateweaver 817 535 282 65.48% 2.72% 62.22%
PatFusty_Snowman 1302 811 491 62.29% 4.33% 59.66%
Quincy_Cyber 4044 2317 1727 57.29% 13.46% 55.77%
Benjamin 869 493 376 56.73% 2.89% 53.44%
Quincy 3522 1869 1653 53.07% 11.72% 51.42%
StrikerJones_Biker 348 197 151 56.61% 1.16% 51.40%
Jericho_Highwayman 875 474 401 54.17% 2.91% 50.87%
Ezili_SmudgeCat 231 130 101 56.28% 0.77% 49.88%
Adora 845 438 407 51.83% 2.81% 48.47%
Etienne_Bee 2734 1376 1358 50.33% 9.10% 48.45%
Jericho_StarCaptain 655 336 319 51.30% 2.18% 47.47%
Ezili 1306 654 652 50.08% 4.35% 47.36%
Jericho 2112 1040 1072 49.24% 7.03% 47.11%
Benjamin_DJ 133 72 61 54.14% 0.44% 45.67%
Etienne 4453 1942 2511 43.61% 14.82% 42.15%
Obyn 763 341 422 44.69% 2.54% 41.16%
Bonnie 1561 661 900 42.34% 5.20% 39.89%
Gwendolin 835 346 489 41.44% 2.78% 38.10%
Gwendolin_Science 1067 413 654 38.71% 3.55% 35.78%
PatFusty 325 129 196 39.69% 1.08% 34.37%
StrikerJones 317 117 200 36.91% 1.05% 31.60%
Obyn_Ocean 300 109 191 36.33% 1.00% 30.89%
Churchill 334 119 215 35.63% 1.11% 30.49%
Churchill_Sentai 300 105 195 35.00% 1.00% 29.60%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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