sands_of_time_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 2988 1914 1074 64.06% 5.78% 62.34%
Jericho 3258 1883 1375 57.80% 6.30% 56.10%
Obyn 4635 2516 2119 54.28% 8.97% 52.85%
Jericho_StarCaptain 567 308 259 54.32% 1.10% 50.22%
Adora_Fateweaver 340 181 159 53.24% 0.66% 47.93%
Etienne_Bee 4086 2014 2072 49.29% 7.90% 47.76%
Ezili 1587 796 791 50.16% 3.07% 47.70%
Quincy_Cyber 2295 1134 1161 49.41% 4.44% 47.37%
Ezili_SmudgeCat 386 202 184 52.33% 0.75% 47.35%
Bonnie 5415 2623 2792 48.44% 10.47% 47.11%
Gwendolin_Science 3267 1575 1692 48.21% 6.32% 46.50%
Benjamin 2216 1074 1142 48.47% 4.29% 46.38%
Churchill_Sentai 1840 895 945 48.64% 3.56% 46.36%
Etienne 6989 3286 3703 47.02% 13.52% 45.85%
StrikerJones 565 282 283 49.91% 1.09% 45.79%
Adora 1566 750 816 47.89% 3.03% 45.42%
StrikerJones_Biker 637 307 330 48.19% 1.23% 44.31%
PatFusty 783 371 412 47.38% 1.51% 43.88%
Quincy 2680 1224 1456 45.67% 5.18% 43.79%
Jericho_Highwayman 692 327 365 47.25% 1.34% 43.53%
Gwendolin 1931 883 1048 45.73% 3.74% 43.51%
Obyn_Ocean 1183 543 640 45.90% 2.29% 43.06%
Churchill 1113 473 640 42.50% 2.15% 39.59%
Benjamin_DJ 677 287 390 42.39% 1.31% 38.67%

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;