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
Jericho 675 416 259 61.63% 10.83% 57.96%
Gwendolin_Science 648 357 291 55.09% 10.40% 51.26%
Etienne_Bee 518 286 232 55.21% 8.31% 50.93%
PatFusty_Snowman 303 160 143 52.81% 4.86% 47.18%
Benjamin 188 101 87 53.72% 3.02% 46.60%
Churchill 276 144 132 52.17% 4.43% 46.28%
Etienne 1037 499 538 48.12% 16.64% 45.08%
Jericho_Highwayman 100 54 46 54.00% 1.60% 44.23%
Ezili_SmudgeCat 33 20 13 60.61% 0.53% 43.93%
Quincy_Cyber 89 45 44 50.56% 1.43% 40.17%
Adora_Fateweaver 63 33 30 52.38% 1.01% 40.05%
StrikerJones 103 51 52 49.51% 1.65% 39.86%
Obyn 169 80 89 47.34% 2.71% 39.81%
Adora 197 90 107 45.69% 3.16% 38.73%
Ezili 141 66 75 46.81% 2.26% 38.57%
Quincy 300 132 168 44.00% 4.81% 38.38%
Jericho_StarCaptain 86 42 44 48.84% 1.38% 38.27%
Churchill_Sentai 267 117 150 43.82% 4.28% 37.87%
Bonnie 502 209 293 41.63% 8.06% 37.32%
Gwendolin 250 106 144 42.40% 4.01% 36.27%
PatFusty 97 43 54 44.33% 1.56% 34.44%
Obyn_Ocean 109 38 71 34.86% 1.75% 25.92%
Benjamin_DJ 46 16 30 34.78% 0.74% 21.02%
StrikerJones_Biker 35 11 24 31.43% 0.56% 16.05%

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;