garden_heroes (view)

20 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Adora 215 131 84 60.93% 5.82% 54.41%
Quincy_Cyber 180 108 72 60.00% 4.87% 52.84%
Jericho_StarCaptain 43 27 16 62.79% 1.16% 48.34%
Quincy 300 158 142 52.67% 8.12% 47.02%
Etienne_Bee 373 193 180 51.74% 10.10% 46.67%
Churchill_Sentai 295 153 142 51.86% 7.99% 46.16%
Gwendolin_Science 231 120 111 51.95% 6.25% 45.51%
Obyn 181 92 89 50.83% 4.90% 43.55%
Jericho_Highwayman 44 25 19 56.82% 1.19% 42.18%
Etienne 616 280 336 45.45% 16.68% 41.52%
Churchill 345 161 184 46.67% 9.34% 41.40%
Ezili 75 39 36 52.00% 2.03% 40.69%
Bonnie 227 107 120 47.14% 6.15% 40.64%
PatFusty_Snowman 63 33 30 52.38% 1.71% 40.05%
Adora_Fateweaver 39 21 18 53.85% 1.06% 38.20%
Benjamin 120 54 66 45.00% 3.25% 36.10%
Jericho 141 60 81 42.55% 3.82% 34.39%
Gwendolin 78 35 43 44.87% 2.11% 33.83%
Ezili_SmudgeCat 30 13 17 43.33% 0.81% 25.60%
Obyn_Ocean 40 10 30 25.00% 1.08% 11.58%

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;