glade_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Adora 2754 1764 990 64.05% 10.94% 62.26%
PatFusty_Snowman 428 265 163 61.92% 1.70% 57.32%
Quincy_Cyber 2414 1347 1067 55.80% 9.59% 53.82%
Churchill_Sentai 1942 1067 875 54.94% 7.71% 52.73%
Benjamin 702 388 314 55.27% 2.79% 51.59%
Churchill 2002 1065 937 53.20% 7.95% 51.01%
Adora_Fateweaver 345 193 152 55.94% 1.37% 50.70%
Quincy 2260 1180 1080 52.21% 8.98% 50.15%
Jericho_StarCaptain 268 132 136 49.25% 1.06% 43.27%
Etienne_Bee 1978 899 1079 45.45% 7.86% 43.26%
Bonnie 1967 881 1086 44.79% 7.81% 42.59%
Etienne 4040 1757 2283 43.49% 16.05% 41.96%
PatFusty 205 97 108 47.32% 0.81% 40.48%
StrikerJones_Biker 153 73 80 47.71% 0.61% 39.80%
Jericho 1002 416 586 41.52% 3.98% 38.47%
Benjamin_DJ 122 57 65 46.72% 0.48% 37.87%
Obyn 454 189 265 41.63% 1.80% 37.10%
Ezili 282 118 164 41.84% 1.12% 36.09%
Gwendolin_Science 663 263 400 39.67% 2.63% 35.94%
Jericho_Highwayman 275 103 172 37.45% 1.09% 31.73%
Ezili_SmudgeCat 137 54 83 39.42% 0.54% 31.23%
StrikerJones 121 48 73 39.67% 0.48% 30.95%
Gwendolin 414 145 269 35.02% 1.64% 30.43%
Obyn_Ocean 246 86 160 34.96% 0.98% 29.00%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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