off_tide_heroes (view)

16 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses, Winrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Quincy_Cyber 400 237 163 59.25% 23.47% 54.43%
PatFusty_Snowman 90 56 34 62.22% 5.28% 52.21%
Etienne_Bee 173 88 85 50.87% 10.15% 43.42%
Benjamin 108 57 51 52.78% 6.34% 43.36%
Jericho_Highwayman 70 38 32 54.29% 4.11% 42.62%
Gwendolin_Science 39 21 18 53.85% 2.29% 38.20%
Quincy 111 52 59 46.85% 6.51% 37.56%
Jericho 102 48 54 47.06% 5.99% 37.37%
Bonnie 92 42 50 45.65% 5.40% 35.47%
Ezili 45 22 23 48.89% 2.64% 34.28%
Etienne 169 68 101 40.24% 9.92% 32.84%
StrikerJones_Biker 25 13 12 52.00% 1.47% 32.42%
Obyn 30 15 15 50.00% 1.76% 32.11%
Jericho_StarCaptain 46 21 25 45.65% 2.70% 31.26%
Adora 50 18 32 36.00% 2.93% 22.70%
StrikerJones 24 10 14 41.67% 1.41% 21.94%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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