sun_palace_heroes (view)

23 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho 624 388 236 62.18% 10.53% 58.37%
Adora_Fateweaver 41 28 13 68.29% 0.69% 54.05%
Etienne_Bee 948 538 410 56.75% 16.00% 53.60%
Jericho_Highwayman 144 87 57 60.42% 2.43% 52.43%
Ezili 226 124 102 54.87% 3.81% 48.38%
Gwendolin_Science 370 192 178 51.89% 6.25% 46.80%
Quincy_Cyber 402 202 200 50.25% 6.79% 45.36%
Quincy 476 237 239 49.79% 8.04% 45.30%
StrikerJones 84 46 38 54.76% 1.42% 44.12%
Benjamin 125 64 61 51.20% 2.11% 42.44%
Churchill_Sentai 377 177 200 46.95% 6.36% 41.91%
Gwendolin 167 82 85 49.10% 2.82% 41.52%
Churchill 266 124 142 46.62% 4.49% 40.62%
PatFusty_Snowman 141 68 73 48.23% 2.38% 39.98%
Etienne 611 251 360 41.08% 10.31% 37.18%
Jericho_StarCaptain 41 21 20 51.22% 0.69% 35.92%
Obyn 181 75 106 41.44% 3.06% 34.26%
StrikerJones_Biker 34 17 17 50.00% 0.57% 33.19%
Obyn_Ocean 135 55 80 40.74% 2.28% 32.45%
Ezili_SmudgeCat 39 18 21 46.15% 0.66% 30.51%
Bonnie 323 112 211 34.67% 5.45% 29.48%
Adora 108 36 72 33.33% 1.82% 24.44%
PatFusty 40 14 26 35.00% 0.68% 20.22%

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;