garden_heroes (view)

21 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho_StarCaptain 42 27 15 64.29% 1.17% 49.79%
Etienne_Bee 412 221 191 53.64% 11.49% 48.83%
Quincy 345 186 159 53.91% 9.62% 48.65%
Obyn 190 105 85 55.26% 5.30% 48.19%
Quincy_Cyber 358 191 167 53.35% 9.98% 48.18%
Jericho_Highwayman 106 60 46 56.60% 2.96% 47.17%
Adora 112 62 50 55.36% 3.12% 46.15%
Churchill 285 142 143 49.82% 7.95% 44.02%
Churchill_Sentai 435 209 226 48.05% 12.13% 43.35%
PatFusty_Snowman 58 32 26 55.17% 1.62% 42.37%
Etienne 416 186 230 44.71% 11.60% 39.93%
Adora_Fateweaver 36 20 16 55.56% 1.00% 39.32%
Bonnie 180 83 97 46.11% 5.02% 38.83%
Gwendolin_Science 78 37 41 47.44% 2.18% 36.35%
Benjamin 81 38 43 46.91% 2.26% 36.05%
Jericho 162 70 92 43.21% 4.52% 35.58%
Ezili_SmudgeCat 51 25 26 49.02% 1.42% 35.30%
Ezili 46 22 24 47.83% 1.28% 33.39%
Gwendolin 81 32 49 39.51% 2.26% 28.86%
Obyn_Ocean 47 20 27 42.55% 1.31% 28.42%
StrikerJones 26 11 15 42.31% 0.73% 23.32%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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