sun_palace_heroes (view)

19 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho 175 122 53 69.71% 10.79% 62.91%
Etienne_Bee 151 89 62 58.94% 9.31% 51.09%
Quincy_Cyber 212 117 95 55.19% 13.07% 48.49%
Ezili 33 21 12 63.64% 2.03% 47.22%
Churchill_Sentai 119 65 54 54.62% 7.34% 45.68%
Gwendolin_Science 73 38 35 52.05% 4.50% 40.59%
Adora 34 18 16 52.94% 2.10% 36.16%
PatFusty 30 16 14 53.33% 1.85% 35.48%
StrikerJones_Biker 102 45 57 44.12% 6.29% 34.48%
Churchill 99 42 57 42.42% 6.10% 32.69%
Benjamin 53 24 29 45.28% 3.27% 31.88%
Obyn 44 20 24 45.45% 2.71% 30.74%
Gwendolin 39 17 22 43.59% 2.40% 28.03%
Jericho_Highwayman 31 14 17 45.16% 1.91% 27.64%
Quincy 85 32 53 37.65% 5.24% 27.35%
Etienne 140 49 91 35.00% 8.63% 27.10%
Bonnie 98 34 64 34.69% 6.04% 25.27%
PatFusty_Snowman 26 11 15 42.31% 1.60% 23.32%
Obyn_Ocean 28 10 18 35.71% 1.73% 17.97%

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;