building_site_scene_heroes (view)

23 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Adora 2538 1530 1008 60.28% 16.58% 58.38%
Adora_Fateweaver 610 366 244 60.00% 3.98% 56.11%
Quincy_Cyber 2835 1590 1245 56.08% 18.52% 54.26%
StrikerJones_Biker 141 83 58 58.87% 0.92% 50.74%
Quincy 2069 1012 1057 48.91% 13.52% 46.76%
Etienne_Bee 909 443 466 48.73% 5.94% 45.49%
StrikerJones 271 139 132 51.29% 1.77% 45.34%
PatFusty_Snowman 152 80 72 52.63% 0.99% 44.69%
Etienne 2620 1199 1421 45.76% 17.12% 43.86%
Ezili 301 141 160 46.84% 1.97% 41.21%
Jericho_StarCaptain 193 87 106 45.08% 1.26% 38.06%
Bonnie 502 204 298 40.64% 3.28% 36.34%
Gwendolin_Science 329 128 201 38.91% 2.15% 33.64%
PatFusty 91 39 52 42.86% 0.59% 32.69%
Jericho 528 193 335 36.55% 3.45% 32.45%
Churchill_Sentai 146 56 90 38.36% 0.95% 30.47%
Jericho_Highwayman 216 76 140 35.19% 1.41% 28.82%
Obyn_Ocean 99 38 61 38.38% 0.65% 28.80%
Obyn 172 61 111 35.47% 1.12% 28.32%
Gwendolin 231 78 153 33.77% 1.51% 27.67%
Benjamin 147 49 98 33.33% 0.96% 25.71%
Ezili_SmudgeCat 43 15 28 34.88% 0.28% 20.64%
Churchill 137 38 99 27.74% 0.89% 20.24%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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