cobra_command_heroes (view)

23 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Winrate, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Etienne_Bee 1353 776 577 57.35% 29.79% 54.72%
Jericho_Highwayman 119 70 49 58.82% 2.62% 49.98%
Quincy 290 156 134 53.79% 6.38% 48.05%
Quincy_Cyber 340 180 160 52.94% 7.49% 47.64%
Benjamin 117 65 52 55.56% 2.58% 46.55%
StrikerJones_Biker 160 84 76 52.50% 3.52% 44.76%
Etienne 666 309 357 46.40% 14.66% 42.61%
StrikerJones 92 48 44 52.17% 2.03% 41.97%
Adora_Fateweaver 29 17 12 58.62% 0.64% 40.70%
Jericho 215 97 118 45.12% 4.73% 38.46%
Bonnie 264 111 153 42.05% 5.81% 36.09%
Churchill_Sentai 101 46 55 45.54% 2.22% 35.83%
PatFusty 44 22 22 50.00% 0.97% 35.23%
PatFusty_Snowman 59 28 31 47.46% 1.30% 34.72%
Obyn 85 37 48 43.53% 1.87% 32.99%
Ezili 124 50 74 40.32% 2.73% 31.69%
Ezili_SmudgeCat 29 14 15 48.28% 0.64% 30.09%
Adora 60 24 36 40.00% 1.32% 27.60%
Gwendolin_Science 105 38 67 36.19% 2.31% 27.00%
Gwendolin 86 31 55 36.05% 1.89% 25.90%
Obyn_Ocean 87 30 57 34.48% 1.92% 24.49%
Jericho_StarCaptain 35 14 21 40.00% 0.77% 23.77%
Churchill 67 20 47 29.85% 1.48% 18.89%

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;