sands_of_time_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Obyn 740 429 311 57.97% 11.26% 54.42%
Jericho 478 276 202 57.74% 7.27% 53.31%
PatFusty_Snowman 359 208 151 57.94% 5.46% 52.83%
StrikerJones 88 54 34 61.36% 1.34% 51.19%
Quincy_Cyber 472 253 219 53.60% 7.18% 49.10%
Etienne_Bee 632 329 303 52.06% 9.61% 48.16%
PatFusty 56 33 23 58.93% 0.85% 46.04%
Jericho_StarCaptain 58 34 24 58.62% 0.88% 45.95%
Benjamin 199 104 95 52.26% 3.03% 45.32%
Churchill_Sentai 571 282 289 49.39% 8.69% 45.29%
Bonnie 496 240 256 48.39% 7.54% 43.99%
StrikerJones_Biker 33 20 13 60.61% 0.50% 43.93%
Quincy 486 229 257 47.12% 7.39% 42.68%
Ezili 265 125 140 47.17% 4.03% 41.16%
Gwendolin_Science 246 113 133 45.93% 3.74% 39.71%
Gwendolin 187 85 102 45.45% 2.84% 38.32%
Jericho_Highwayman 113 50 63 44.25% 1.72% 35.09%
Ezili_SmudgeCat 54 26 28 48.15% 0.82% 34.82%
Etienne 528 199 329 37.69% 8.03% 33.56%
Adora_Fateweaver 42 20 22 47.62% 0.64% 32.51%
Churchill 178 70 108 39.33% 2.71% 32.15%
Adora 112 46 66 41.07% 1.70% 31.96%
Obyn_Ocean 136 48 88 35.29% 2.07% 27.26%
Benjamin_DJ 45 14 31 31.11% 0.68% 17.58%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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