garden_heroes (view)

20 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
Adora 195 117 78 60.00% 6.06% 53.12%
Ezili 55 34 21 61.82% 1.71% 48.98%
Etienne_Bee 244 131 113 53.69% 7.58% 47.43%
Etienne 711 357 354 50.21% 22.08% 46.54%
Quincy 217 114 103 52.53% 6.74% 45.89%
Quincy_Cyber 90 50 40 55.56% 2.80% 45.29%
Gwendolin_Science 225 116 109 51.56% 6.99% 45.03%
Jericho_StarCaptain 44 26 18 59.09% 1.37% 44.56%
Adora_Fateweaver 47 27 20 57.45% 1.46% 43.31%
Churchill_Sentai 156 79 77 50.64% 4.84% 42.80%
Obyn 95 50 45 52.63% 2.95% 42.59%
Churchill 285 137 148 48.07% 8.85% 42.27%
Benjamin 134 67 67 50.00% 4.16% 41.53%
Ezili_SmudgeCat 49 25 24 51.02% 1.52% 37.02%
Obyn_Ocean 51 25 26 49.02% 1.58% 35.30%
Bonnie 232 96 136 41.38% 7.20% 35.04%
Jericho 134 58 76 43.28% 4.16% 34.89%
PatFusty_Snowman 73 30 43 41.10% 2.27% 29.81%
Gwendolin 68 28 40 41.18% 2.11% 29.48%
Jericho_Highwayman 35 13 22 37.14% 1.09% 21.13%

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;