splashdown_heroes (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Obyn 96 67 29 69.79% 2.19% 60.61%
Quincy_Cyber 1173 693 480 59.08% 26.73% 56.27%
StrikerJones_Biker 208 116 92 55.77% 4.74% 49.02%
PatFusty 78 46 32 58.97% 1.78% 48.06%
Bonnie 523 261 262 49.90% 11.92% 45.62%
Quincy 367 180 187 49.05% 8.36% 43.93%
Adora 155 79 76 50.97% 3.53% 43.10%
PatFusty_Snowman 34 20 14 58.82% 0.77% 42.28%
Adora_Fateweaver 45 25 20 55.56% 1.03% 41.04%
Etienne_Bee 283 129 154 45.58% 6.45% 39.78%
Churchill_Sentai 109 53 56 48.62% 2.48% 39.24%
Ezili 71 36 35 50.70% 1.62% 39.07%
Jericho 228 97 131 42.54% 5.20% 36.13%
Etienne 456 179 277 39.25% 10.39% 34.77%
Jericho_StarCaptain 63 29 34 46.03% 1.44% 33.72%
Churchill 83 34 49 40.96% 1.89% 30.38%
Jericho_Highwayman 51 21 30 41.18% 1.16% 27.67%
Obyn_Ocean 63 25 38 39.68% 1.44% 27.60%
Benjamin 55 22 33 40.00% 1.25% 27.05%
Gwendolin 91 31 60 34.07% 2.07% 24.33%
Gwendolin_Science 68 22 46 32.35% 1.55% 21.23%
StrikerJones 57 15 42 26.32% 1.30% 14.88%

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;