sun_palace_heroes (view)

23 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Winrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho 780 490 290 62.82% 10.76% 59.43%
Etienne_Bee 1051 579 472 55.09% 14.50% 52.08%
Gwendolin_Science 792 412 380 52.02% 10.93% 48.54%
Quincy_Cyber 206 111 95 53.88% 2.84% 47.08%
PatFusty_Snowman 270 136 134 50.37% 3.73% 44.41%
Churchill 399 194 205 48.62% 5.50% 43.72%
Churchill_Sentai 318 156 162 49.06% 4.39% 43.56%
Quincy 489 232 257 47.44% 6.75% 43.02%
Etienne 901 411 490 45.62% 12.43% 42.36%
StrikerJones 84 43 41 51.19% 1.16% 40.50%
Benjamin 163 77 86 47.24% 2.25% 39.58%
Obyn 185 86 99 46.49% 2.55% 39.30%
Adora_Fateweaver 78 39 39 50.00% 1.08% 38.90%
Adora 171 79 92 46.20% 2.36% 38.73%
Bonnie 461 195 266 42.30% 6.36% 37.79%
Jericho_Highwayman 125 58 67 46.40% 1.72% 37.66%
Ezili 200 89 111 44.50% 2.76% 37.61%
PatFusty 48 24 24 50.00% 0.66% 35.85%
Jericho_StarCaptain 66 31 35 46.97% 0.91% 34.93%
Gwendolin 231 92 139 39.83% 3.19% 33.51%
Obyn_Ocean 137 56 81 40.88% 1.89% 32.64%
Ezili_SmudgeCat 29 13 16 44.83% 0.40% 26.73%
StrikerJones_Biker 32 12 20 37.50% 0.44% 20.73%

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;