cobra_command_heroes (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Etienne_Bee 1169 703 466 60.14% 24.33% 57.33%
Benjamin 136 84 52 61.76% 2.83% 53.60%
Bonnie 315 161 154 51.11% 6.56% 45.59%
Etienne 742 364 378 49.06% 15.45% 45.46%
StrikerJones 148 79 69 53.38% 3.08% 45.34%
Quincy_Cyber 537 261 276 48.60% 11.18% 44.38%
Jericho_Highwayman 116 62 54 53.45% 2.41% 44.37%
StrikerJones_Biker 270 132 138 48.89% 5.62% 42.93%
Jericho_StarCaptain 46 26 20 56.52% 0.96% 42.20%
Quincy 295 140 155 47.46% 6.14% 41.76%
Ezili 83 38 45 45.78% 1.73% 35.06%
Adora 100 44 56 44.00% 2.08% 34.27%
Jericho 168 67 101 39.88% 3.50% 32.48%
Obyn 65 27 38 41.54% 1.35% 29.56%
Churchill 128 46 82 35.94% 2.66% 27.63%
Gwendolin 65 25 40 38.46% 1.35% 26.63%
Churchill_Sentai 132 45 87 34.09% 2.75% 26.00%
PatFusty 39 16 23 41.03% 0.81% 25.59%
Gwendolin_Science 101 32 69 31.68% 2.10% 22.61%
Ezili_SmudgeCat 28 11 17 39.29% 0.58% 21.20%
Adora_Fateweaver 32 11 21 34.38% 0.67% 17.92%
Obyn_Ocean 54 16 38 29.63% 1.12% 17.45%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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