garden_heroes (view)

21 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 72 51 21 70.83% 1.88% 60.33%
Adora 166 109 57 65.66% 4.33% 58.44%
Adora_Fateweaver 58 38 20 65.52% 1.51% 53.28%
Churchill_Sentai 214 123 91 57.48% 5.58% 50.85%
Ezili_SmudgeCat 99 59 40 59.60% 2.58% 49.93%
Obyn 186 106 80 56.99% 4.85% 49.87%
Quincy 243 133 110 54.73% 6.33% 48.47%
Jericho 175 96 79 54.86% 4.56% 47.48%
Churchill 366 185 181 50.55% 9.54% 45.42%
Jericho_StarCaptain 38 23 15 60.53% 0.99% 44.98%
Gwendolin_Science 274 134 140 48.91% 7.14% 42.99%
Etienne 814 371 443 45.58% 21.21% 42.16%
Etienne_Bee 375 170 205 45.33% 9.77% 40.29%
Ezili 97 47 50 48.45% 2.53% 38.51%
Quincy_Cyber 59 29 30 49.15% 1.54% 36.40%
Bonnie 307 128 179 41.69% 8.00% 36.18%
PatFusty 59 27 32 45.76% 1.54% 33.05%
Benjamin_DJ 23 12 11 52.17% 0.60% 31.76%
Jericho_Highwayman 32 15 17 46.88% 0.83% 29.58%
Gwendolin 73 22 51 30.14% 1.90% 19.61%
Benjamin 43 14 29 32.56% 1.12% 18.55%

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;