sun_palace_heroes (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho 650 388 262 59.69% 11.36% 55.92%
StrikerJones_Biker 306 174 132 56.86% 5.35% 51.31%
Etienne_Bee 794 417 377 52.52% 13.87% 49.05%
Quincy 353 190 163 53.82% 6.17% 48.62%
Gwendolin_Science 357 190 167 53.22% 6.24% 48.05%
Quincy_Cyber 444 228 216 51.35% 7.76% 46.70%
Benjamin 169 91 78 53.85% 2.95% 46.33%
Ezili 161 84 77 52.17% 2.81% 44.46%
PatFusty 62 35 27 56.45% 1.08% 44.11%
Churchill_Sentai 323 155 168 47.99% 5.64% 42.54%
PatFusty_Snowman 142 72 70 50.70% 2.48% 42.48%
Gwendolin 219 105 114 47.95% 3.83% 41.33%
Etienne 630 274 356 43.49% 11.01% 39.62%
StrikerJones 90 42 48 46.67% 1.57% 36.36%
Obyn 89 41 48 46.07% 1.55% 35.71%
Adora 119 53 66 44.54% 2.08% 35.61%
Churchill 194 81 113 41.75% 3.39% 34.81%
Bonnie 273 109 164 39.93% 4.77% 34.12%
Jericho_StarCaptain 66 29 37 43.94% 1.15% 31.97%
Jericho_Highwayman 65 28 37 43.08% 1.14% 31.04%
Obyn_Ocean 153 54 99 35.29% 2.67% 27.72%
Ezili_SmudgeCat 22 10 12 45.45% 0.38% 24.65%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW sun_palace_heroes AS 
WITH sun_palace AS
    (SELECT *
    FROM matches
    WHERE map = 'sun_palace')
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 sun_palace) * 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 sun_palace
                  UNION ALL
                  SELECT rHero             AS Hero,
                         NOT playerLeftWin AS Win
                  FROM sun_palace)
            GROUP BY Hero))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;