sun_palace_heroes (view)

24 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 456 302 154 66.23% 6.33% 61.89%
Jericho_Highwayman 198 126 72 63.64% 2.75% 56.94%
PatFusty_Snowman 190 118 72 62.11% 2.64% 55.21%
Gwendolin_Science 1064 546 518 51.32% 14.78% 48.31%
Obyn 296 155 141 52.36% 4.11% 46.68%
Etienne 1382 671 711 48.55% 19.19% 45.92%
Adora 237 123 114 51.90% 3.29% 45.54%
Obyn_Ocean 135 70 65 51.85% 1.88% 43.42%
Churchill 233 115 118 49.36% 3.24% 42.94%
Churchill_Sentai 114 59 55 51.75% 1.58% 42.58%
Bonnie 691 318 373 46.02% 9.60% 42.30%
PatFusty 131 65 66 49.62% 1.82% 41.06%
Benjamin_DJ 33 19 14 57.58% 0.46% 40.71%
Etienne_Bee 803 354 449 44.08% 11.15% 40.65%
Quincy 253 117 136 46.25% 3.51% 40.10%
Jericho_StarCaptain 104 51 53 49.04% 1.44% 39.43%
Quincy_Cyber 111 54 57 48.65% 1.54% 39.35%
Adora_Fateweaver 46 24 22 52.17% 0.64% 37.74%
StrikerJones_Biker 85 41 44 48.24% 1.18% 37.61%
Ezili 168 74 94 44.05% 2.33% 36.54%
StrikerJones 70 33 37 47.14% 0.97% 35.45%
Gwendolin 270 110 160 40.74% 3.75% 34.88%
Benjamin 77 33 44 42.86% 1.07% 31.80%
Ezili_SmudgeCat 53 22 31 41.51% 0.74% 28.24%

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;