sands_of_time_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Winrate, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 555 352 203 63.42% 8.32% 59.42%
Jericho 384 215 169 55.99% 5.76% 51.02%
Obyn 838 449 389 53.58% 12.56% 50.20%
Etienne_Bee 764 389 375 50.92% 11.45% 47.37%
Churchill_Sentai 245 126 119 51.43% 3.67% 45.17%
Jericho_StarCaptain 60 34 26 56.67% 0.90% 44.13%
Bonnie 549 263 286 47.91% 8.23% 43.73%
StrikerJones 75 41 34 54.67% 1.12% 43.40%
Gwendolin_Science 430 206 224 47.91% 6.44% 43.19%
Benjamin 273 131 142 47.99% 4.09% 42.06%
Ezili 192 94 98 48.96% 2.88% 41.89%
Quincy 470 217 253 46.17% 7.04% 41.66%
Etienne 674 305 369 45.25% 10.10% 41.49%
Quincy_Cyber 190 92 98 48.42% 2.85% 41.31%
Jericho_Highwayman 82 41 41 50.00% 1.23% 39.18%
Adora_Fateweaver 49 25 24 51.02% 0.73% 37.02%
Gwendolin 246 106 140 43.09% 3.69% 36.90%
Obyn_Ocean 127 57 70 44.88% 1.90% 36.23%
Adora 172 72 100 41.86% 2.58% 34.49%
Churchill 135 56 79 41.48% 2.02% 33.17%
PatFusty 49 21 28 42.86% 0.73% 29.00%
StrikerJones_Biker 41 17 24 41.46% 0.61% 26.38%
Ezili_SmudgeCat 43 17 26 39.53% 0.64% 24.92%
Benjamin_DJ 29 10 19 34.48% 0.43% 17.18%

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;