sands_of_time_heroes (view)

23 rows

✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Losses, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 576 380 196 65.97% 9.77% 62.10%
Jericho_StarCaptain 65 42 23 64.62% 1.10% 52.99%
Jericho 473 251 222 53.07% 8.02% 48.57%
Etienne_Bee 377 202 175 53.58% 6.39% 48.55%
Obyn 526 275 251 52.28% 8.92% 48.01%
Bonnie 601 297 304 49.42% 10.19% 45.42%
Gwendolin_Science 392 197 195 50.26% 6.65% 45.31%
PatFusty 92 50 42 54.35% 1.56% 44.17%
Ezili 121 64 57 52.89% 2.05% 44.00%
Gwendolin 247 120 127 48.58% 4.19% 42.35%
Etienne 905 411 494 45.41% 15.35% 42.17%
Benjamin 341 157 184 46.04% 5.78% 40.75%
Quincy 317 144 173 45.43% 5.38% 39.94%
Adora_Fateweaver 59 31 28 52.54% 1.00% 39.80%
Adora 181 79 102 43.65% 3.07% 36.42%
Churchill_Sentai 121 51 70 42.15% 2.05% 33.35%
Churchill 75 33 42 44.00% 1.27% 32.77%
StrikerJones 75 32 43 42.67% 1.27% 31.47%
Jericho_Highwayman 62 27 35 43.55% 1.05% 31.21%
Quincy_Cyber 97 35 62 36.08% 1.65% 26.53%
Ezili_SmudgeCat 33 14 19 42.42% 0.56% 25.56%
Benjamin_DJ 54 20 34 37.04% 0.92% 24.16%
Obyn_Ocean 88 29 59 32.95% 1.49% 23.13%

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;