garden_heroes (view)

23 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses, Winrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Quincy 286 171 115 59.79% 8.56% 54.11%
Quincy_Cyber 419 243 176 58.00% 12.54% 53.27%
Obyn 97 57 40 58.76% 2.90% 48.97%
Churchill 274 140 134 51.09% 8.20% 45.18%
Churchill_Sentai 416 203 213 48.80% 12.46% 43.99%
Etienne_Bee 316 154 162 48.73% 9.46% 43.22%
Jericho 183 91 92 49.73% 5.48% 42.48%
PatFusty_Snowman 60 33 27 55.00% 1.80% 42.41%
Benjamin 102 53 49 51.96% 3.05% 42.26%
Bonnie 191 90 101 47.12% 5.72% 40.04%
Etienne 437 194 243 44.39% 13.08% 39.74%
Adora 54 26 28 48.15% 1.62% 34.82%
Gwendolin 59 28 31 47.46% 1.77% 34.72%
Gwendolin_Science 66 29 37 43.94% 1.98% 31.97%
Ezili 48 22 26 45.83% 1.44% 31.74%
Jericho_Highwayman 49 22 27 44.90% 1.47% 30.97%
Ezili_SmudgeCat 27 13 14 48.15% 0.81% 29.30%
StrikerJones_Biker 61 25 36 40.98% 1.83% 28.64%
PatFusty 44 19 25 43.18% 1.32% 28.55%
Adora_Fateweaver 28 13 15 46.43% 0.84% 27.96%
Jericho_StarCaptain 31 14 17 45.16% 0.93% 27.64%
Obyn_Ocean 45 16 29 35.56% 1.35% 21.57%
StrikerJones 37 11 26 29.73% 1.11% 15.00%

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;