garden_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Adora 1206 713 493 59.12% 4.20% 56.35%
Quincy_Cyber 1960 1098 862 56.02% 6.83% 53.82%
Adora_Fateweaver 369 216 153 58.54% 1.29% 53.51%
PatFusty_Snowman 472 264 208 55.93% 1.64% 51.45%
Ezili_SmudgeCat 463 259 204 55.94% 1.61% 51.42%
Obyn 1100 595 505 54.09% 3.83% 51.15%
Quincy 2126 1132 994 53.25% 7.41% 51.12%
Etienne_Bee 2244 1156 1088 51.52% 7.82% 49.45%
Churchill_Sentai 2223 1125 1098 50.61% 7.75% 48.53%
Churchill 2624 1319 1305 50.27% 9.14% 48.35%
Ezili 522 271 251 51.92% 1.82% 47.63%
Jericho 1234 604 630 48.95% 4.30% 46.16%
Etienne 5228 2482 2746 47.48% 18.22% 46.12%
Jericho_StarCaptain 394 201 193 51.02% 1.37% 46.08%
Jericho_Highwayman 401 202 199 50.37% 1.40% 45.48%
Benjamin 804 392 412 48.76% 2.80% 45.30%
Bonnie 2116 941 1175 44.47% 7.37% 42.35%
Gwendolin_Science 1398 628 770 44.92% 4.87% 42.31%
Benjamin_DJ 184 82 102 44.57% 0.64% 37.38%
Gwendolin 599 240 359 40.07% 2.09% 36.14%
Obyn_Ocean 385 158 227 41.04% 1.34% 36.13%
StrikerJones 198 85 113 42.93% 0.69% 36.03%
StrikerJones_Biker 168 72 96 42.86% 0.59% 35.37%
PatFusty 280 114 166 40.71% 0.98% 34.96%

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;