garden_heroes (view)

20 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Losses, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Benjamin 142 87 55 61.27% 4.48% 53.26%
Quincy_Cyber 553 313 240 56.60% 17.46% 52.47%
PatFusty_Snowman 43 28 15 65.12% 1.36% 50.87%
Etienne_Bee 248 135 113 54.44% 7.83% 48.24%
Obyn 99 55 44 55.56% 3.13% 45.77%
Ezili 27 17 10 62.96% 0.85% 44.75%
Churchill_Sentai 319 158 161 49.53% 10.07% 44.04%
Quincy 222 112 110 50.45% 7.01% 43.87%
Churchill 313 151 162 48.24% 9.88% 42.71%
Adora 90 46 44 51.11% 2.84% 40.78%
Etienne 434 195 239 44.93% 13.70% 40.25%
Jericho 100 49 51 49.00% 3.16% 39.20%
Gwendolin_Science 43 23 20 53.49% 1.36% 38.58%
Bonnie 209 91 118 43.54% 6.60% 36.82%
Jericho_Highwayman 53 25 28 47.17% 1.67% 33.73%
Gwendolin 45 19 26 42.22% 1.42% 27.79%
Jericho_StarCaptain 39 16 23 41.03% 1.23% 25.59%
StrikerJones_Biker 62 22 40 35.48% 1.96% 23.57%
Obyn_Ocean 34 13 21 38.24% 1.07% 21.90%
StrikerJones 29 10 19 34.48% 0.92% 17.18%

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;