sun_palace_heroes (view)

23 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho 583 343 240 58.83% 8.72% 54.84%
Etienne_Bee 711 406 305 57.10% 10.63% 53.46%
Benjamin 271 156 115 57.56% 4.05% 51.68%
StrikerJones_Biker 596 320 276 53.69% 8.91% 49.69%
Quincy_Cyber 627 334 293 53.27% 9.38% 49.36%
Churchill_Sentai 492 262 230 53.25% 7.36% 48.84%
Ezili 184 97 87 52.72% 2.75% 45.50%
Quincy 344 164 180 47.67% 5.14% 42.40%
Jericho_Highwayman 110 55 55 50.00% 1.64% 40.66%
Gwendolin_Science 285 132 153 46.32% 4.26% 40.53%
Etienne 709 312 397 44.01% 10.60% 40.35%
PatFusty_Snowman 101 50 51 49.50% 1.51% 39.75%
PatFusty 119 56 63 47.06% 1.78% 38.09%
Churchill 326 141 185 43.25% 4.87% 37.87%
Adora 165 75 90 45.45% 2.47% 37.86%
StrikerJones 135 61 74 45.19% 2.02% 36.79%
Obyn 143 64 79 44.76% 2.14% 36.61%
Bonnie 350 138 212 39.43% 5.23% 34.31%
Adora_Fateweaver 56 26 30 46.43% 0.84% 33.37%
Ezili_SmudgeCat 39 19 20 48.72% 0.58% 33.03%
Obyn_Ocean 113 47 66 41.59% 1.69% 32.51%
Jericho_StarCaptain 59 26 33 44.07% 0.88% 31.40%
Gwendolin 144 53 91 36.81% 2.15% 28.93%

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;