splashdown_heroes (view)

11 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Quincy 94 59 35 62.77% 9.51% 52.99%
Quincy_Cyber 186 104 82 55.91% 18.83% 48.78%
Obyn 29 19 10 65.52% 2.94% 48.22%
Bonnie 81 45 36 55.56% 8.20% 44.73%
StrikerJones_Biker 68 36 32 52.94% 6.88% 41.08%
Churchill_Sentai 29 16 13 55.17% 2.94% 37.07%
Etienne 120 52 68 43.33% 12.15% 34.47%
Adora 36 18 18 50.00% 3.64% 33.67%
Etienne_Bee 71 30 41 42.25% 7.19% 30.76%
Jericho 59 22 37 37.29% 5.97% 24.95%
Gwendolin 35 14 21 40.00% 3.54% 23.77%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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