precious_space_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho 3071 1746 1325 56.85% 8.92% 55.10%
Adora_Fateweaver 651 375 276 57.60% 1.89% 53.81%
Jericho_Highwayman 1354 752 602 55.54% 3.93% 52.89%
Obyn 2231 1209 1022 54.19% 6.48% 52.12%
Quincy_Cyber 2453 1312 1141 53.49% 7.13% 51.51%
Benjamin 1887 1011 876 53.58% 5.48% 51.33%
Adora 1366 734 632 53.73% 3.97% 51.09%
Quincy 2817 1477 1340 52.43% 8.19% 50.59%
Ezili_SmudgeCat 249 137 112 55.02% 0.72% 48.84%
PatFusty_Snowman 333 177 156 53.15% 0.97% 47.79%
Bonnie 4482 2192 2290 48.91% 13.02% 47.44%
Jericho_StarCaptain 731 370 361 50.62% 2.12% 46.99%
Etienne_Bee 2699 1313 1386 48.65% 7.84% 46.76%
StrikerJones_Biker 276 143 133 51.81% 0.80% 45.92%
Ezili 715 347 368 48.53% 2.08% 44.87%
Benjamin_DJ 300 149 151 49.67% 0.87% 44.01%
Etienne 4990 2224 2766 44.57% 14.50% 43.19%
StrikerJones 381 182 199 47.77% 1.11% 42.75%
Gwendolin 783 336 447 42.91% 2.28% 39.45%
Obyn_Ocean 489 199 290 40.70% 1.42% 36.34%
Gwendolin_Science 929 361 568 38.86% 2.70% 35.72%
Churchill_Sentai 509 190 319 37.33% 1.48% 33.13%
PatFusty 226 89 137 39.38% 0.66% 33.01%
Churchill 490 181 309 36.94% 1.42% 32.67%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW precious_space_heroes AS 
WITH precious_space AS
    (SELECT *
    FROM matches
    WHERE map = 'precious_space')
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 precious_space) * 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 precious_space
                  UNION ALL
                  SELECT rHero             AS Hero,
                         NOT playerLeftWin AS Win
                  FROM precious_space)
            GROUP BY Hero))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;