inflection_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Adora 3827 2379 1448 62.16% 17.68% 60.63%
Benjamin 681 406 275 59.62% 3.15% 55.93%
Benjamin_DJ 127 80 47 62.99% 0.59% 54.59%
Churchill_Sentai 858 481 377 56.06% 3.96% 52.74%
PatFusty_Snowman 457 261 196 57.11% 2.11% 52.57%
Quincy_Cyber 2413 1288 1125 53.38% 11.15% 51.39%
Adora_Fateweaver 397 211 186 53.15% 1.83% 48.24%
Quincy 2404 1181 1223 49.13% 11.11% 47.13%
Churchill 850 410 440 48.24% 3.93% 44.88%
Etienne 3181 1451 1730 45.61% 14.70% 43.88%
Etienne_Bee 1235 545 690 44.13% 5.71% 41.36%
Jericho_StarCaptain 228 108 120 47.37% 1.05% 40.89%
PatFusty 185 88 97 47.57% 0.85% 40.37%
Jericho 809 352 457 43.51% 3.74% 40.09%
Bonnie 1756 734 1022 41.80% 8.11% 39.49%
Obyn 432 185 247 42.82% 2.00% 38.16%
Jericho_Highwayman 234 104 130 44.44% 1.08% 38.08%
Gwendolin 446 169 277 37.89% 2.06% 33.39%
Ezili_SmudgeCat 99 40 59 40.40% 0.46% 30.74%
StrikerJones_Biker 97 38 59 39.18% 0.45% 29.46%
Ezili 219 77 142 35.16% 1.01% 28.84%
Gwendolin_Science 465 153 312 32.90% 2.15% 28.63%
Obyn_Ocean 161 53 108 32.92% 0.74% 25.66%
StrikerJones 85 29 56 34.12% 0.39% 24.04%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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