sands_of_time_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Obyn 428 252 176 58.88% 7.20% 54.22%
Jericho 518 300 218 57.92% 8.71% 53.66%
PatFusty_Snowman 303 179 124 59.08% 5.10% 53.54%
Benjamin 311 173 138 55.63% 5.23% 50.11%
Churchill_Sentai 326 179 147 54.91% 5.48% 49.51%
Jericho_StarCaptain 65 38 27 58.46% 1.09% 46.48%
Quincy_Cyber 510 256 254 50.20% 8.58% 45.86%
PatFusty 105 57 48 54.29% 1.77% 44.76%
Etienne_Bee 620 290 330 46.77% 10.43% 42.85%
Gwendolin_Science 193 96 97 49.74% 3.25% 42.69%
Quincy 359 171 188 47.63% 6.04% 42.47%
StrikerJones_Biker 155 78 77 50.32% 2.61% 42.45%
Adora 145 72 73 49.66% 2.44% 41.52%
Etienne 509 228 281 44.79% 8.56% 40.47%
Bonnie 417 185 232 44.36% 7.01% 39.60%
Ezili 184 86 98 46.74% 3.09% 39.53%
Obyn_Ocean 139 63 76 45.32% 2.34% 37.05%
Jericho_Highwayman 90 42 48 46.67% 1.51% 36.36%
Gwendolin 201 83 118 41.29% 3.38% 34.49%
Ezili_SmudgeCat 30 15 15 50.00% 0.50% 32.11%
Churchill 124 49 75 39.52% 2.09% 30.91%
Adora_Fateweaver 48 21 27 43.75% 0.81% 29.72%
StrikerJones 81 31 50 38.27% 1.36% 27.69%
Benjamin_DJ 85 29 56 34.12% 1.43% 24.04%

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;