sun_palace_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Adora_Fateweaver 62 47 15 75.81% 0.83% 65.15%
PatFusty_Snowman 234 146 88 62.39% 3.14% 56.19%
Jericho 673 398 275 59.14% 9.04% 55.42%
Obyn 281 157 124 55.87% 3.77% 50.07%
Gwendolin_Science 937 494 443 52.72% 12.58% 49.52%
Etienne 1317 649 668 49.28% 17.68% 46.58%
Jericho_Highwayman 173 93 80 53.76% 2.32% 46.33%
Etienne_Bee 570 279 291 48.95% 7.65% 44.84%
Churchill_Sentai 245 121 124 49.39% 3.29% 43.13%
Quincy_Cyber 160 79 81 49.38% 2.15% 41.63%
Bonnie 739 330 409 44.65% 9.92% 41.07%
Churchill 274 127 147 46.35% 3.68% 40.45%
StrikerJones_Biker 52 28 24 53.85% 0.70% 40.30%
Quincy 206 97 109 47.09% 2.77% 40.27%
Jericho_StarCaptain 185 87 98 47.03% 2.48% 39.83%
Obyn_Ocean 184 86 98 46.74% 2.47% 39.53%
Ezili 191 88 103 46.07% 2.56% 39.00%
StrikerJones 83 41 42 49.40% 1.11% 38.64%
Benjamin 180 81 99 45.00% 2.42% 37.73%
Adora 252 107 145 42.46% 3.38% 36.36%
Benjamin_DJ 99 44 55 44.44% 1.33% 34.66%
Ezili_SmudgeCat 43 21 22 48.84% 0.58% 33.90%
Gwendolin 213 84 129 39.44% 2.86% 32.87%
PatFusty 95 40 55 42.11% 1.28% 32.18%

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;