sun_palace_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho 4878 2995 1883 61.40% 9.15% 60.03%
PatFusty_Snowman 1397 760 637 54.40% 2.62% 51.79%
Etienne_Bee 5294 2811 2483 53.10% 9.93% 51.75%
Jericho_Highwayman 1025 559 466 54.54% 1.92% 51.49%
Gwendolin_Science 5060 2655 2405 52.47% 9.49% 51.09%
Adora_Fateweaver 440 243 197 55.23% 0.83% 50.58%
Quincy_Cyber 2294 1198 1096 52.22% 4.30% 50.18%
StrikerJones_Biker 1237 639 598 51.66% 2.32% 48.87%
Churchill_Sentai 2319 1152 1167 49.68% 4.35% 47.64%
Ezili 1541 770 771 49.97% 2.89% 47.47%
StrikerJones 691 353 338 51.09% 1.30% 47.36%
Benjamin 1245 624 621 50.12% 2.34% 47.34%
Etienne 8330 3918 4412 47.03% 15.63% 45.96%
Quincy 2692 1286 1406 47.77% 5.05% 45.88%
Obyn 1562 752 810 48.14% 2.93% 45.67%
Jericho_StarCaptain 730 357 373 48.90% 1.37% 45.28%
Churchill 2271 1066 1205 46.94% 4.26% 44.89%
Ezili_SmudgeCat 356 176 180 49.44% 0.67% 44.24%
PatFusty 645 309 336 47.91% 1.21% 44.05%
Adora 1556 699 857 44.92% 2.92% 42.45%
Bonnie 4407 1914 2493 43.43% 8.27% 41.97%
Gwendolin 1835 787 1048 42.89% 3.44% 40.62%
Obyn_Ocean 1151 483 668 41.96% 2.16% 39.11%
Benjamin_DJ 352 148 204 42.05% 0.66% 36.89%

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;