garden_heroes (view)

23 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Adora_Fateweaver 66 46 20 69.70% 1.65% 58.61%
Ezili_SmudgeCat 78 52 26 66.67% 1.94% 56.20%
Adora 183 110 73 60.11% 4.56% 53.01%
Etienne 747 386 361 51.67% 18.62% 48.09%
PatFusty_Snowman 83 48 35 57.83% 2.07% 47.21%
Ezili 91 52 39 57.14% 2.27% 46.98%
Churchill_Sentai 272 143 129 52.57% 6.78% 46.64%
Etienne_Bee 316 163 153 51.58% 7.88% 46.07%
Churchill 388 198 190 51.03% 9.67% 46.06%
Quincy 262 135 127 51.53% 6.53% 45.48%
Obyn 161 81 80 50.31% 4.01% 42.59%
StrikerJones 30 18 12 60.00% 0.75% 42.47%
Jericho 180 88 92 48.89% 4.49% 41.59%
Bonnie 289 132 157 45.67% 7.20% 39.93%
PatFusty 44 24 20 54.55% 1.10% 39.83%
Benjamin_DJ 51 26 25 50.98% 1.27% 37.26%
Jericho_StarCaptain 113 51 62 45.13% 2.82% 35.96%
Quincy_Cyber 106 48 58 45.28% 2.64% 35.81%
Obyn_Ocean 61 29 32 47.54% 1.52% 35.01%
Benjamin 136 58 78 42.65% 3.39% 34.33%
Jericho_Highwayman 42 19 23 45.24% 1.05% 30.19%
Gwendolin_Science 224 71 153 31.70% 5.58% 25.60%
Gwendolin 82 26 56 31.71% 2.04% 21.64%

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;